i am building a stored procedure to handle a database search. is there
any way i can take an input search string and create an array of
strings from it by parsing for a ' ' delimiter. then afterwards
dynamically create a variable for each item in the string array.

example. say my SP receives the input search parameter "bloggs joe
brisbane australia"

somehow i want to dynamically create a variable
for "bloggs", "joe", "brisbane" and "australia".

thanks