Charles Baldo
asked on
SQL Split output
Hi I have a column in Microsoft SQL 2008 that it data is delimited by a "." every column has it and only one delimiter
so I have something like this
RecordID , TableFieldName
------------- -------------------------- ---------
1 Profile.Firstname
2 Profile.LastName
3 Contact.PhoneNumber
I would want to have output like this
Record Table Field
---------- ------------- ----------------------
1 Profile FirstName
2 Profile LastName
3 Contact PhoneNumber
so I have something like this
RecordID , TableFieldName
------------- --------------------------
1 Profile.Firstname
2 Profile.LastName
3 Contact.PhoneNumber
I would want to have output like this
Record Table Field
---------- ------------- ----------------------
1 Profile FirstName
2 Profile LastName
3 Contact PhoneNumber
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER