dlmedici
New User
Joined: 05 Oct 2006 Posts: 1
|
|
|
|
At the moment I am without a mainframe connection, so I cannot experiment.
Assume the following columns on TABLE_X:
Code: |
CLAIM_NBR INTEGER
DATE_VALUE VARCHAR(255) |
How can I write a query that will return all claim numbers where the VARCHAR column is not a date? Will the following work:
Code: |
SELECT CLAIM_NBR
FROM TABLE_X
WHERE DATE(DATE_VALUE) IS NULL |
|
|