Archives of the TeradataForum

Message Posted: Fri, 08 Jul 2005 @ 18:22:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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....

Thanks

Raj

	<Prev	Next>		<<First	<Prev	Next>	Last>>