Trimming Char field

[andreis]

Hi:

I have a field with FirstName, MiddleName, and LastName entered one after another, divided by a space. How can I trim the column so that only LastName would remain?

Thanks.

Andrei

 

[PFR]

LEFT ( PATINDEX ( '% %', column )

 

[PFR]

forgot last &quot" !

 

[RickCole]

As long your column has at least 2 fields with a space between this should work:

SELECT REVERSE(SUBSTRING(REVERSE(column_name),1,PATINDEX ('% %',(REVERSE(column_name)))-1)) from tablename

Rick.

 

[lestermadoc]

"I've done this before. It may be functions by the name of "rtrim" and "ltrim" that handle this. I will keep an eye out for an answer for you - and you should search for these functions.