SQL command For Not Null Value Field

[retkehing]

What is the command for selecting a record with not null value on particuler field? I have tried to achieve the following

[SIZE=2]OleDbCommand1.CommandText = [/SIZE][SIZE=2][COLOR=#800000]"SELECT DATALENGTH(portrait), portrait FROM Emp_Profile WHERE delete_status='No' AND emp_no='"[/COLOR][/SIZE][SIZE=2] & emp_no_search_string & [/SIZE][SIZE=2][COLOR=#800000]"' AND NOT NULL(portrait)"
[/COLOR][/SIZE]

 

[TechGnome]

"IS NOT NULL"

-tg