Are you using SQL server OR oracle?
>I have a 6 numeric character field in a table that is supposed to be a >date value in the format of 'mmddyy'. But a small percentage (5 out of >2.5 million for my first sampling) are not actually data recognizable as >a legitimate date. > >Is there any way I can easily query the data for records with a value >that can *NOT* be converted into a date in the format of 'mmddyy'? In >other words is their anyway to do something like an exception trap on >the to_date(field,'mmddyy') function to return records that will fail it? > >TIA >Ian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3194 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
