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

Reply via email to