0

How to print only numeric value from one column

For example : column contains values R123, R456,.... And i want to print 123,456.... Using sql query

14th Mar 2020, 7:55 PM
sumith kumar chowdhary
2 odpowiedzi
+ 1
Use this PATINDEX('%[^0-9]%', column_name)
14th Mar 2020, 8:04 PM
A͢J
A͢J - avatar
0
SELECT column FROM table WHERE column not like '%[^0-9]%' and column != ''
14th Mar 2020, 8:07 PM
BroFar
BroFar - avatar