Drop Down Parameter List

I have a string with values that are separated by a space. It looks like this:DAY MICS SUN FIX STD.I would like to take the string and make it a drop down list in a report parameter.I have tried the split function but it errors on me.How can I accomplish this?

Is the value dynamic?
If not, could have manually put into parameter list

If it's dynamic, I think best way is to use a Query for the parameters
and do the split in T-SQL

split function
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/TreatYourself.asp|||Thanks for responding. Yes the value is dynamic. When you say do the split in T-SQL (Transaction SQL?) how do you do that? I dropped the code from the article link you sent me into the code section under report properties. I get an error "There is an error on line 0 of custom code: [BC30188] Declaration expected." Maybe that is not where it goes? My query looks like this so far: SELECT ImplodedsubKeywordsList WHERE FORMULA("@.Contains(keywords;\"KI Product Demand Category\")" ) Do I just tack that code onto the end of it somehow? Thank you.