>><snip>
>>>>
>>>>
>>>>And Not Empty(tablename.columnname)
>>>>
>>>>
>>>
>>>Look at the DATALENTH() function in SQL-DOL. Also if the field accepts null values you'd use IS NULL.
>>
>>George,
>>
>>Why would you use DATALENTH() function in this case when 'NOT LEN(tablename.columnname)=0' does the job?
>
>Sergey,
>
>LEN() only applies to strings. DATALENGTH() can be used on any type, including binary and image.
I still don't get how DATALENGTH() can be used to check for EMPTY().
--sb--