VB.NET:
SELECT VoterName,
SUBSTRING(VoterName, 1, CHARINDEX(',', VoterName) - 1) AS LName,
LTRIM(SUBSTRING(VoterName, CHARINDEX(',', VoterName) + 1, CHARINDEX(' ', LTRIM(SUBSTRING(VoterName, CHARINDEX(',', VoterName) + 1, LEN(VoterName)))))) AS FName,
SUBSTRING(LTRIM(SUBSTRING(VoterName, CHARINDEX(',', VoterName) + 1, LEN(VoterName))), CHARINDEX(' ', LTRIM(SUBSTRING(VoterName, CHARINDEX(',', VoterName) + 1, LEN(VoterName)))) + 1, LEN(LTRIM(SUBSTRING(VoterName, CHARINDEX(',', VoterName) + 1, LEN(VoterName))))) AS MName
FROM [VoterFileMarch]
WHERE (CHARINDEX(',', VoterName) > 0)
Last edited by a moderator: