I love this, I learn as much from the articles as I do the discussions. Great article.

I have never used either of these functions but in my current position I can see lots of places where I can utilize them.
Thanks, great stuff.

Try this, it came from one of my favorite SQL books, SQL Queries for Mere Mortals (second edition). Use the ESCAPE option.

SELECT ProductName, ProductCode

FROM Products

WHERE ProductCode...