SELECT Null Fields

[accconst]

I am using ASP pasges to querey a SQL database. I want to create a record set that will return all rows in which the job_close_dt field is null. This is my current code:

sql = "SELECT * FROM JCJobs "
set rsJobs = Server.CreateObject("ADODB.Recordset")
rsJobs.Open sql, conn, 3, 3

How do I modify this to achieve what I have described?

Thanks!

 

[DreXor]

sql = "SELECT * FROM JCJobs where job_close_dt is null"

DreX
aKa - Robert

 

[DreXor]

hmmm .. *scratches head* might be "=" instead of "is"

been a long morning, although i think either will work


DreX
aKa - Robert

 

[amorous]

Try this:

sql = "SELECT * FROM JCJobs WHERE ISNULL(job_close_dt) OR job_close_dt="" "

-VJ

 

[Veep]

It's "IS NULL" for SQLServer. ISNULL is a SQLServerfunction:

ISNULL ( check_expression , replacement_value )

 

[amorous]

Thanks for the correction veep.

-VJ

 

[Veep]

Sure. After making that mistake several hundred times I think I finally got it.

 

[accconst]

DreXor, your solution worked. Thanks so much!

Solution:
sql = "SELECT * FROM JCJobs where job_close_dt is null