Click here to Skip to main content
16,020,261 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 19: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
 
Share this answer
 
SQL
SELECT Substring('DAta123',5,7)
 
Share this answer
 

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