Thank You so much!!

Sorry! one more thing ....

Below query fails when I have data with only one word as: select 'noname' UNION ALL select 'noname'

select

SUBSTRING(BadColumn, CHARINDEX(',', BadColumn) + 1, DATALENGTH(BadColumn))

+ '...

Thank You!!!

Ok...here it is.. hope this is clear..

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable

( MyColumnName varchar(50))

INSERT INTO #mytable(MyColumnName)

SELECT 'LN1, FN1' UNION ALL

SELECT 'Lastname2, Firstname2' UNION ALL

SELECT 'Lastnm3,...