Jeff - thanks, I'll keep this in mind in case I have to do something similar in the future.

The advantage to making it a UDF is for code re-use. I was thinking he may need to this in other places and it would make it easier although he could certainly use reverse the words directly in his query if necessary.

Mark