CODEWITHSUNDEEP
splitmultiple-columnsnvarchar
Anjali
Anjali

Reputation: 1718

How to split a string column based on '/' in sqlserver 2005?

Hi

I don't know how to split a dd/mm/yyyy column into dd as Col1, mm as Col2, yyyy as Col3. It is a string Field, so I can't use Select Convert() query.

Upvotes: 0

Views: 50

Answers (1)

Anshuman
Anshuman

Reputation: 587

I found this as helpful when I was doing a similar thing a few days ago: T-SQL split string

Just play around with that code and you will get your solution!

Cheers!

Upvotes: 1

Related Questions