Split string in Sql server 2008

Question

0.00/5 (No votes)

See more:

Hello All,

I have a value in one column like '12345-1234'... I have to split this string and put in different columns.

Can anyone help me on this...

Output is like below

12345
1234

Thanks In Advance...

Regards,
Naveen

Posted 18-Jul-14 20:50pm

NaVeN Kumar

Add a Solution

Comments

nilesh sawardekar 19-Jul-14 3:24am

Is it serialize .. i mean to say 12345-1234-12345-1234.and so on?

2 solutions

Solution 2

Hi Naven,

check this Query

SQL

SELECT LEFT(id, CHARINDEX('-',id)-1) as ID1,   
 RIGHT(id, CHARINDEX('-',id) - 2)  as ID2
FROM [Table_2]

VB

ID1	ID2
12345	1234

thanks

Posted 20-Jul-14 20:28pm

vani suresh

Updated 20-Jul-14 20:33pm

v3

Comments

NaVeN Kumar 21-Jul-14 4:41am

Thanks for the solution Vani Suresh, but it is not working for all formats...

If I have given 12345-123 then I got like below

ID1 ID2
12345 -123

Add a Solution

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

Peter Leow · Accepted Answer · 2014-07-18T21:04:00

Solution 1

Try this:

SQL

SELECT LEFT(columnname, Charindex('-', columnname) - 1) as leftcolumn,
       RIGHT(columnname, Charindex('-', Reverse(columnname)) - 1)  as rightcolumn
FROM table1

Posted 18-Jul-14 21:04pm

Peter Leow

Comments

NaVeN Kumar 21-Jul-14 4:36am

Perfect thanks for the solution Peter... :)

Peter Leow 21-Jul-14 10:51am

You are welcome.

Split string in Sql server 2008

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Split string in Sql server 2008

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us