>>>Hi,
>>>
>>>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.
>>
>>
>>mytable.myfield IS NOT NULL
>
>Thank you very much, Brandon.


Glad to help.