I have to parse only numbers from a string and store them into two variables. The column where the string is really a free form. It can take spaces, wild chars, numbers etc.
for example -
5 %-10% =@num1 = 5 and @num2 = 10
20 %-30% =@num1 = 20 and @num2 = 30
25 -30 % = @num1 = 25 and num2 = 30
40% - 50 = @num1 = 40 and num2 = 50
How would I eliminate everything other than numbers and get the left part of number in @num1 and right side of number in @num2 variables.