Mitchel,

Below is the one which i tried my own.

Table Name: Dating

Select * from Dating

Output:

Date ...

Well, All of you suggest to use DTS or BCP option to split the data rather than doing with SQL.

Thank you for all !

🙂

yes you are correct,we can seperate it in the DTS itself.

But i want to do this with sql query.

Yes,I used DTS import/export wizard.

Also can you help me to achieve the same task with Sql query ?

Can you give me the syntax of BCP ?

Andras,

I already did what you have mentioned.

TableName: Imp_Text

Remarks

50,Karthik,1982,+91-044-994012345,5000.00

60,Vijay,1974,+91-044-998012345,8000.00

70,Arun,1992,+91-044-992012345,6500.00

Now i want to split it in the below format.

50 Karthik 1982 +91-044-994012345 5000.00

60 Vijay 1974 ...

I am using Sql2000.

Hi SQLZ,

Really sorry !

Sorry for not mentioned it in my earlier post.

Yes it is working fine in Sqlserver2000.

My Team is using SQL2000 and Sybase12.5.3.

It is not working in Sybase12.5.3.

But the thing is, Sybase and Sqlserver are almost same in some generic query execution.

if we take our situation...

I am getting 1.

The following rows are displaying.

select * from Dating

Output:

-------------------------------------------

Date

----...

Code:

-------------------------------------------------------------------------------

Declare @strSQL VarChar(255)

declare @count int

select @count = 0

Select @count = @count + 1, @strSQL = (Case When @strSQL Is Null Then Date

...

SQLZ,

It is not working.

...