How about: SELECT fname WITH MPAR.STATUS.DATE CONV "" = "[/]"
Since you seem to know exactly the kind of erroneous data you want to find. On Tue, Jan 29, 2013 at 3:38 PM, Greg Coelho <coe...@american.edu> wrote: > All, > > Can anyone help me with a query to find instances where an external date > has been written to a date field? I would like to use ...WITH > MPAR.STATUS.DATE LIKE ".. > ./..." (the dates would be in the fomat: '12/16/12', but this field is set > with external formatting so I end up bringing back everything. Is there a > way I can 'turn off' formatting for this field within the query? > > Thanks, > > Greg > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users