在Sql server 2008中拆分字符串 [英] Split string in Sql server 2008

问题描述

Hello All，



我在一列中有一个值，如'12345-1234'......我必须将此字符串拆分并放入不同的列。



任何人都可以帮我这个...



输出如下



12345

1234



在此先感谢...



问候，

Naveen

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

推荐答案

试试这个：

Try this:

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

Hi Naven，



查看此查询

Hi Naven,

check this Query

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

ID1	ID2
12345	1234

谢谢

thanks

这篇关于在Sql server 2008中拆分字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！