<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?
--sb--