How to print only numeric value from one column

Question

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

Answer 1

Use this

PATINDEX('%[^0-9]%', column_name)

Answer 2

SELECT column FROM table WHERE column not like '%[^0-9]%' and column != ''