><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.
George
Ubi caritas et amor, deus ibi est