How to Isolate value through sql query

[macsql1]

Hi All,

I have a question. Using sql server 2005. A table with 3 column, where column1 contains data in numeric(1234)then one space followed by alphabets(Book).

I need to separate Column1 value to Column2 and Column3.

eg1.
Column1: 1234 Book
(Output )
Column2: 1234
Column3: Book

eg2.
Column1: 34 Bookself
(Output )
Column2: 34
Column3: Bookself

Here we have to differentiate value by SPACE between numeric value and alphabets value.

How to proceed. Thanks in advance.

-Mac

 

[r937]

SELECT SUBSTRING(Column1,1,CHARINDEX(' ',Column1)) AS Column2
, SUBSTRING(Column1,CHARINDEX(' ',Column1)+1,999) AS Column3
FROM ...

r937.com | rudy.ca