>I've seen it used a LOT in building up SELECT statements, if you have a form that has various check boxes and selections etc., then the validation will build up the WHERE clause to include in a single statement.
>
>SELECT * FROM myTable;
>&lcWhereClause
>
>Kev
Ok, Ok, Ok. I should have excluded SQL statements. I use it for this too, just because we don't have a choice. Notice however that VB programmers don't need macro substitution to run ad-hoc SQL statements, because they have avenues for submitting SQL as a string. I've been lobbying for a VFP equivalent for some time now.
Erik Moore
Clientelligence