>>thanks - I'll try it
>>I would still vote in favor of

"where myfield = @myparm"

being "NULL aware" though
>
>Ken, take a look at SET ANSI_NULLS.
>
>-Mike

Thanks Mike - I had seen this but, if I'm reading it correctly, I wouldn't be able to set this "on the fly" in a particular stored procs - like the way you can with "Set EXACT" for instance in VFP. AM I missing something there?

TIA,