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 40 times
0
a_horse_with_no_name
- 497,550
- 91
- 775
- 843
TechGuy
- 3,939
- 13
- 50
- 78
-
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