Home Forums SQL Server 2005 Administering Split a column RE: Split a column
homebrew01
SSC Guru
Points: 55539
More actions
June 2, 2013 at 10:19 am
#1620330
In a simple world, it looks like a good opportunity to use the '*' to split the field into 3 columns:
FName
MName
LName
Gives you much more flexibility for future needs.