This works with 2008. Can't find the function in 2005 however. Is there a way in 2005 to do the same thing?

thanks

.

did not add service packs..sp2 and now sp3, case closed

Here is the corrected version then. The previous worked but I assumed you could prefix with the wildcard char as well as suffix.

This version works fine for...

You appear to be correct. ANyone know a work around for this? Or is this a limitation?

THanks...it was late last night and I didn't have the 'what if' part of my brain working.

Unfortunately, I will forget all of this in a couple of hours...

thanks...once again (what the heck is wrong with this forum..this is the 3rd time i have tried to post this) i will take a look at this later on today...

thanks i'll take a look

thanks, i'll take a look

Lowell, the reply you came up with before works and IMHO is ingenius (but i am just a grasshopper) but yes, it is taking a bit of time to run...

Hi Gail, I guess the main reason is that I don't know enough about full-texting in SQL Server but I am assuming it probably has its own language thus necessitating...

Hi Gail thanks for the reply. Just looking for a shortcut to help improve system performance on searches. Full-text indexing unfortunately is not an option. Here is...

Thanks for the replies. My largest column contains close to 900 bytes. I can change the ntext to varchar but then I get an error about placing a...

Yes, giving the user a choice of whether to search on product name, sku, descripition or product id. Recently discoverd that I can concatenate and execute a string e.g. exec(SELECT...

ummm, ya....it just occured to me...out of embarrassment, i came here to delete this question, and ouch, you had already answered it.

i have not had my coffee this...