This seems to mostly work:

RIGHT(LastName,(LEN(LastName))-CHARINDEX(',',LastName)) As FirstNameOnly

I needed to use Right Trim but I didn't know how many positions to trim to. So, I did this:

Right(LastName, C)

A = Length of whole string

B = Position of Comma

C = A-B (Remaining chars)