Awesome! You guys rock! Thanks again to all who helped out!

I figured it out and it works beautifully! Thanks so much for your help!

Yes, sorry, all of the words occur at the end of the string. I'm a sql newbie, so I'm afraid I do no completly understand the syntax of the STUFF...

Sorry, I'm not following you. :unsure: Can you give me another example after looking at all of my original code?

select rowid, accountnumber, tenantnumber, accountname, serviceaddress, billtoaddress1,

case

when billtoaddress1...