Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
sql remove non numeric characters
Rodia
Programming language:
SQL
2021-04-28 11:15:12
0
Q:
sql remove non numeric characters
Darius Miliauskas
Code:
SQL
2021-07-16 12:37:55
SELECT REGEXP_REPLACE( fieldname, '[^[:digit:]]', '' ) AS newfieldname FROM tablename
0
Tags
remove
character
sql
characters
Related
sql delete all values in a column
sql server delete records that have a single duplicate column
function to remove special characters in sql
sql server delete column
sql delete caracter list
is not numeric sql
t-sql remove all non-alphanumeric characters from a string
sql strip characters from column
New to Communities?
Join the community