Using Null with Select Statement

[PedroA]

Hi,

The below code works fine.

 [FONT=Consolas][SIZE=2][FONT=Consolas][SIZE=2]Query = [/SIZE][/FONT][/SIZE][/FONT][FONT=Consolas][SIZE=2][COLOR=#a31515][FONT=Consolas][SIZE=2][COLOR=#a31515][FONT=Consolas][SIZE=2][COLOR=#a31515]"SELECT cid FROM tdata WHERE hno = '100' AND eid IS NULL"[/COLOR][/SIZE][/FONT][/COLOR][/SIZE][/FONT][/COLOR][/SIZE][/FONT]

However, I cannot find a way to check if 'eid' is not null. 'IS NOT NULL' doesn't work.

How can this be done?

Appreciate any help.

Cheers

 

[Herman]

Try 'NOT ISNULL(fieldname)'

 

[PedroA]

Try 'NOT ISNULL(fieldname)'

The 'ISNULL(fieldname)' part works fine but not with the 'NOT'. The error I get is 'NullReferenceException was unhandled'

 

[PedroA]

Found my problem. I was using .ToString with my command execute. All working now.