DECLARE @FullName VARCHAR(100)
SET @FullName = 'John,Doe'
SELECT SUBSTRING(@FullName, 1, CHARINDEX(',', @FullName) - 1) AS [FirstName],
SUBSTRING(@FullName, CHARINDEX(',', @FullName) + 1, LEN(@FullName)) AS [LastName]
More Examples:
http://www.sql-server-helper.com/tips/split-name.aspx[
^]