I have a table that contains a date field (dtnDOB). I want to pull all records from this table that have a value in this field. I've tried the following queries with no luck:
select * from <table> where dtndob<>''
select * from <table> where dtndob<>0
select * from <table> where dtndob>0
I'm not sure how to for the WHERE clause so that the result set excludes blank dates.
select * from <table> where dtndob<>''
select * from <table> where dtndob<>0
select * from <table> where dtndob>0
I'm not sure how to for the WHERE clause so that the result set excludes blank dates.