How to judge the field in IMAGE format is empty?

sam7978465

How to judge the field of IMAGE format is empty in MS-SQL? I use CRYSTAL for reports. If it is empty, it cannot be exported as a PDF file. If there are pictures, it can be exported as a PDF file. How can I solve it?

3521565

Is isdbnull feasible?

klongvv

datable.rows [0] ["fieldName"]. ToString (). Trim (). Length == 0 is empty.

mageli

isnull (****) sql syntax

zhouji700

select count (*) from yourtable where isnull (field name)
or:
select count (*) from yourtable where field name is null

rcloud

select field name from table where datalength (field name)> 0