thanks azadi, that did indeed work. mike >before you start pestering your host to modify the jdbc connection >string, try this: > >SELECT customer_id, IF(ISNULL(STR_TO_DATE(LEFT(customer_dob, 10), >'%Y-%m-%d')), 'Not Defined', customer_dob) AS dob >FROM customer >WHERE 1=1 > >hth > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > > > >Sim >>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf-talk/message.cfm/messageid:313564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
