I have a string in my query like this,
X-AL33DX
I want to get 33 only from Query .
I'll try to use REPLACE but can't
REPLACE(REPLACE('X-AL33DX', '-', 'x'), ',', '')
Asked
Active
Viewed 41 times
0
-
1what is your RDBMS? Also you have to explain a litle more what format your string will be like `33XX22` is possible? – Juan Carlos Oropeza Mar 21 '17 at 04:33
-
SQL Server .... – TechGuy Mar 21 '17 at 04:33
-
@JuanCarlosOropeza Yes those 33 can come anywhere in the string after X- – TechGuy Mar 21 '17 at 04:34
-
1If the duplicate answers don't work for you, or your problem is somehow markedly different, then drop a comment and I can remove the dupe. From what I can see, you want to remove letters (and hyphen), leaving you with the number `33.`. – Tim Biegeleisen Mar 21 '17 at 04:35
-
check this post http://stackoverflow.com/questions/16667251/query-to-get-only-numbers-from-a-string – Balan Mar 21 '17 at 15:19