DB Field CONTAINS

Cool! I love learning something I didn't know before, Dinghus.

Thanks,

Mike

Oh. It has to be
SELECT *
FROM table
CONTAINS ('#searchword#')

Hmmmmm CONTAINS may be just for T-SQL or ORACLE then.

Sorry - I see you already had the answer.

I don't know if it's just my machine, but it keeps taking forever to submit a page in my browser.

Use "LIKE", i.e. -

SELECT *
FROM products
WHERE description LIKE ('%#searchword#%')

- Mike

SELECT *
FROM products
WHERE description CONTAINS ('#searchword#')

This doesn't work. Get a syntax error. What simple little thing am I
overlooking?

That Contains is a ColdFusion Function. The SQL equivlent is LIKE.

SELECT *
FROM products
WHERE description LIEK('%#searchword#%')

Note the '%' percent signs. These are the wild card characters in SQL.