Split a string in a sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

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 4-Nov-13 19:23pm

Member 9991522

Updated 4-Nov-13 19:55pm

v2

Add a Solution

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

2 solutions

Add a Solution

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

coded007 · Answer 1 · 2013-11-04T19:52:00

Solution 2

SQL

SELECT Substring('DAta123',5,7)

Posted 4-Nov-13 19:52pm

coded007

thatraja · Answer 2 · 2013-11-04T19:49:00

Solution 1

Use RIGHT[^] or SUBSTRING[^] functions

Posted 4-Nov-13 19:49pm

thatraja

Split a string in a sql server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Split a string in a sql server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us