sending null back to sql server 6.5
i am sending a query to a table located in sql server
using
Visual Basic. the query checks whether a field is
null or not.
for example: table_example
field_1 field_2
abc 2
(null) 3
i want to send a query "select * from table_example where
field_1 = null". But when I send the query I get error. So
I set a String variable(str) to NULL and tried "select *
from table_example where field_1 = '" & str & "' ". But
this also doesn't work. Anyone know how I can check if a
field contains a null. Thanks.
G. Rush
