Separating Data inside a Varchar Field

[delaap]

Hi,

I'm looking to separate data from one field into three.
For example
"Mr Dave Maloney" sits currently in one field
I have 3 other fields named Title, Initials, Surname
I'm looking to place "Mr" into the Title field, "Dave" into "Initials" and "Maloney" into the Surname Field.
I know there is a simple way of doing this but my head is Frazzled.
Thanks

 

[tlbroadbent]

If you have SQL 2000, check out the UDF, fn_Split() at the following link.

http://msdn.microsoft.com/library/en-us/dnsqlmag01/html/TreatYourself.asp

Otherwise, check SWYNK.COM for some parsing scripts.

http://www.swynk.com/sqlscripts/misc7.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Guest_imported]

Thanks a lot, you have been a great help.