>>One point I might add is to try to avoid macros if at all possible since I think they pollute memory. Your first example could be written:
>>
>>IF UPPER(myOffOnStringVariable) = "ON"
>> SET EXCLUSIVE ON
>>ELSE
>> SET EXCLUSIVE OFF
>>ENDIF
>>
>>Which will run more effeciently.
>
>Gosh David,
>
>I thought that with the advent of structured programming and OOP worrying about memory pollution was passe (well...at least in the halls of MS land)...hell, memory's cheap...<g>

David,
I don't know about memory usage, but David's IF / ENDIF example will run a tiny bit faster than " SET EXCLUSIVE &MyOffOnStringVariable "
David.
(Sure are alot of Davids out here today!)