Synametrics Technologies

What term or method can I use in WinSQL to search a string for a term?  I tried Like without much result

select count (distinct client_id) as clients,

from kea467_table
where web_page_nm contains 'happy'

select count (distinct client_id) as clients

from kea467_table

where web_page_nm contains 'happy'

Hi,

The answer to this question depends upon the back-end database. Which database are you using for the back-end? AFAIK, "contains" is only supported by Informix. Try rewirting your query like:

select count(distinct client_id) as clients from kea467_table where web_page_nm like '%happy%'

Imran