sqlteradatateradata-sql-assistantteradatasql

Filter unwanted characters from a column in Teradata


I have a Phone number column in my table with values only being numbers and no special characters. for one of the column I got a value coming in as ":1212121212".

I will need to filter this record and any records coming in with any special characters in teradata. Can anyone help on this.

I have tried the below solutions but it is not working

where (REGEXP_SUBSTR(column_name, '[0-9]+')<>1 or column_name is null )

Solution

  • Thanks Jonas. Since I need only numeric values and the length should be 10, I tried the below and it worked. This would ignore all the additional special characters.

    (regexp_similar(Column,'[0-9]{10}')=1)