Re: help newbie question!

If you want to retrieve all records where a particulare column contains the word 'hello', say, then use

SELECT *
FROM table
WHERE col LIKE '%hello%'

The '%' matched any number of characters when used with the LIKE operator. If you want it case insensitive then use

WHERE UPPER(col) LIKE UPPER('%hello%') i.e convert both side to upper case.

HTH

--
Alan D. Mills

To email remove NOSPAM from address.
Marc Godard wrote in message <351ED489.372F282D_at_glen-net.ca>...


>I have a query that

> select *

> from <table>

> where <var> Contains like '<var>'

>                     ^^^^^^^^

>

>i'm looking for this (but it doesn't work)

>i know there is a way you can do this but i forget!?

>

>can anyone help me?

>

>