Archives of the TeradataForum
Message Posted: Fri, 08 Jul 2005 @ 18:22:55 GMT
I have a column in a table that contains alpha numeric characters(something like: 0154A258D). But there are few records in this field that are junk (something like: =7F =E5,=7F =F4, =7F=0E ,=7F=FD =,=7F=FD=0F ,=7F=FD=1F =06,=E9w!=7F=FD) and there a lots of them like this.
Valid data for this field can only contain combination of values from A to Z and 0 to 9. I am trying to select only the valid values and ignore the junk. Is there a way to select only the valid values....
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|