Create SQL Query to bring results from a field which does not follow a required format
Posted on 2009-03-29
hmmm....In a particular table, namely 'Invoice', I have a field 'Due Date', by mistake there was no condition set for entering the data in the field from the application side because of which there are now wrong faulty data in that particular field. Now I need to inform users to rectify their mistake but for that I need to select the faulty set of data.
So I need a select query which should be able to show data from the field 'Due Date' if it does not follow the format, "(0?[1-9]|1)/(0?[1-9]|[0-9]|3)/(19|20)\d\d"
I am not a database guy, hence not sure if I am making sense, please tell me if more information is needed.