Yes, thanks for your help- I did get it working.  Sorry it took so long to respond- I'm telecommuting after coming off maternity leave and am working some very whacky...

Right- it works fine as a select statement.  I want to take it and turn it into a function so I only need to call it one time.

One thing to keep in mind. I use cf also. Often the quotes/apostrophes look fine in the database and show on websites properly.

But then we use our data to populate...