Simple SQL Statment Not working, whats wrong

[Ibuprofen]

SELECT * FROM Task_Questionnaire WHERE (DAG_Flag='D') AND (TIR Like 'T***-***') ORDER BY RecNumber; This works in access, however, once on my dot net page, and I call it, it doesnt. In all actually I am just trying to get were TIR = NULL, I've tried Is Not Null, and Not Null, and that doesnt seem to function either!

[Ibuprofen]

Answer is strSQL="SELECT * FROM Task_Questionnaire WHERE (DAG_Flag='D') AND (TIR Like 'T%%%-%%%') ORDER BY RecNumber; Use of % for patterns!

[N a v a n e e t h]

SELECT * FROM Task_Questionnaire WHERE (DAG_Flag='D') AND (TIR is NULL) ORDER BY RecNumber; Will this work ?

---

printf("Navaneeth!!") www.w3hearts.com

[Ibuprofen]

I am sorry I was tired last night and mistyped, I was actually trying to get it were it wouldnt pull any NULL values in.