How to convert string '5$' to number?

Question

Transact SQL

Zdarov)
I have several fields in the table where records of this kind are '5$', '15$', '24$'.
I need to sort the data by records where it is a string no more than '18$'.
How to convert such a record to a number so that sorting can be done?

Answer 1

for example, use cast, after clearing non-numeric characters, for example, using replace

Answer 2

DECLARE @Test TABLE ( S VARCHAR(5))
INSERT @Test VALUES ('5$'), ('15$'), ('24$')

SELECT S FROM @Test WHERE RIGHT( '00' + S, 3 ) < '18$'