Click here to Skip to main content
14,743,331 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
HI I have the data- DAta123.d123a,ad123,d123ata

I want to separate the string-123 alone
i want a query to split the string
i want to extract only numeric characters
Posted
Updated 4-Nov-13 20:55pm
v2
Comments
ArunRajendra 5-Nov-13 1:25am
   
Do you mean extract only numeric value or extract 3 characters from right?
Member 9991522 5-Nov-13 1:35am
   
extract 3 charcaters from right

Use RIGHT[^] or SUBSTRING[^] functions
   
SELECT Substring('DAta123',5,7)
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900