Archives of the TeradataForum
Message Posted: Tue, 24 Apr 2007 @ 20:52:52 GMT
We have an existing table with a character column containing US telephone numbers that are unfortunately stored in a variety of formats.
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|