I have a table with values('99','-99','99.99','-99.99','99-','$99','99#','99.99.99','-99.99.99' ,'-99-99.99'); I need output like this(99,-99,99.99,-99.99);
I tried with like operator but facing problem.
I have a table with values('99','-99','99.99','-99.99','99-','$99','99#','99.99.99','-99.99.99' ,'-99-99.99'); I need output like this(99,-99,99.99,-99.99);
I tried with like operator but facing problem.
1条答案
按热度按时间atmip9wb1#
Not sure that I understood your logic correctly but looks like you need to get only numbers. If yes, you can use isNumeric or Try_Parse for checking your string values.
Both variants return the same result set: