Something like this?

WITH CTE([MemberName])AS(

SELECT 'Cazares, Luis' UNION ALL

SELECT 'Cazares, Luis A')

SELECT LEFT( MemberName, CHARINDEX(',', MemberName) - 1) LastName,

SUBSTRING( MemberName, CHARINDEX(',', MemberName) + 1, LEN( MemberName)) FirstName

FROM CTE