Select Statementw where null

Tangerine · March 22nd, 2004, 01:48 AM

hey everyone

i have this select statement

selectItem = "select * from UserItem where userItem.itemId=item.itemid and userId = " & 222 & " and dateActualReturned = " & null & ""

but ofcourse i get an error when it reads null values.. how can i byoass this problem

What Comes Around Goes Around!

Tangerine · March 22nd, 2004, 03:08 AM

Never mind

i did it

Code:

selectItem = "select * from UserItem,Item where userItem.itemId=item.itemid and userId = " & 222 & " and (dateActualReturned is null)"

What Comes Around Goes Around!