split of a filed - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

split of a filed

Author

Topic

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2008-03-14 : 09:44:59

hi

i have table that has field name fullname and contains data in
this way ak,paga. I need this field to be split into three fields
firstname middle and last in a select statement.

thanks in advance

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-03-14 : 09:47:04

see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033

KH
[spoiler]Time is always against us[/spoiler]