You shouldn't use it in the first place. MYTABLE.MYFLD IS NOT NULL is SQL way to do it in VFP as well.

>
>How do I change expression !ISNULL(MYTABLE.MYFLD) in a SQL Select to be valid for SQL Server. I have looked at a the fox.wikis page VFPSQL - TSQL - Mapping but still can't seem to figure the right syntax.
>
>Thank you in advance for your help.