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
Updated 4-Nov-13 20:55pm
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