>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?
>
>Thanks, Randy
Macro substitution is great in this case. Both the WHERE clause and the ORDER BY clause are very likely candidates for this kind of thing - you could have both clauses as variables; but there is also the alternative to macro-substitute the entire command, in other words:
lcCommand = "select ..."
&lcCommand
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)