Manie, good article! Myself, I don't think that I've ever used patindex, but I use the other string functions heavily. It's amazing how many people don't do string manipulation: I recently taught a group of skilled programmers an Intro to SQL Server/Database Theory class (they were Cobol & Oracle users mainly) and they were amazed what I could do with basic string manipulation.