> -----Original Message-----
> From: Grant Brown [mailto:grant@...]
> I need to create a custom search string in a stored procedure subject to
> the fields that the user has selected.

Sorry for the garbage mail that just slipped my finger before this.

Anyway, you could solve your problem with the EXECUTE STATEMENT. This allows you to execute arbitary dynamic SQL code like this

In your SP write
EXECUTE STATEMENT :my_var_containing_SQL.

It is not a very good way and I don't know if there is a better way but I would be very pleased to hear about it I it exists.

Tim