I would like to split or remove the Mr., Ms., Ms, Mr, from the front of the FullName?
I have this in the FullName column:
Mr. John Smith
Ms. Jone Smith
Ms John Smith
I would like:
In the FullName column
I have this
LTRIM(RTRIM(SUBSTRING(FullName, 0, CHARINDEX(' ', FullName)))) As Surname
but all that does is gives me another column with Mr. Ms.
and does not take out the Mr. from FullName
I would like either/or/both in Access query or/both TSQL query
Please help and thanks...