>Hi. Doing a SQL where end-user has a choice of any number of options. Should I do a
>macro substitution. Is there a tutorial on this? Is there an easier way?

If you let the customer type in things to search for, make sure you allow for the possibility of a SQL injection attack.

Say you use something like the following code:

lcName = "Avery 4143"
SELECT * ;
	FROM HOME(1) + "labels" ;
	WHERE name = "&lcName."

All well and good, right? But what if the user adds a bit to the "label name"?

lcName = [Avery"+IIF(EXECSCRIPT('? "Hi there!"'), " ", " ") + "4143]
SELECT * ;
	FROM HOME(1) + "labels" ;
	WHERE name = "&lcName."

(My original code had MESSAGEBOX() in it, but that turned out to be too painful. :-) )