simple SQL question

[gtbikerider]

Hi

I want to get a recordset that in English would look like...

select *
from calendar
where title contains 'open day'

...But "contains" is not correct syntax. How can this be done in SQL? or must I extract all and then use a

<cfif #title# contains &quot;open day&quot;>

--
John

 

[Sarky78]

you can use the like function in SQL and then use some wild cards, so that the query will return records with 'open day' anywhere in the field

so you query will look like:

select *
from calendar
where title LIKE '%open day%'

hope this helps !

 

[gtbikerider]

Worked a treat. Thanks for the fast response. --
John