> -----Original Message-----
> 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".
>

Check out a procedure I wrote which was originally designed to do this type
of thing (http://www.fbtalk.net/viewtopic.php?id=238), there are also a
couple of example procs:

Count number of words - (http://www.fbtalk.net/viewtopic.php?id=239)
Count number of lines - (http://www.fbtalk.net/viewtopic.php?id=241)

Hih

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage