Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Phone number character data cleaning?
From:   Duell, Bob


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

For example:

     (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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023