How to change the property of any string into numeric property?

Question

Example :"Learn" is a string of varchar type but how to change the string property into numeric property and the value will be same as it is.

Answer 1

you have to use the query TO NUM ("Learn")

Answer 2

You can't convert 'Learn' to a numeric value. You'll get a type conversion error. However, if you have a valid number as a varchar, you can convert it.

SELECT CONVERT(INT,'125');
SELECT CAST('125' AS INT);

Answer 3

how do you do this