Archives of the TeradataForum

Message Posted: Tue, 24 Apr 2007 @ 20:52:52 GMT

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

Hi,

We have an existing table with a character column containing US telephone numbers that are unfortunately stored in a variety of formats.

For example:

     9999999999
     (999)999-9999
     (999) 999-9999
     999.999.9999
     999/999-9999
     999/999.9999

Can anyone suggest a clever way to cast this column to integer, ignoring all the non-numeric characters? Unfortunately, I'm not allowed to create a UDF, so I need a pure SQL solution.

Thanks very much,

Bob Duell

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