The like clause of sql

From: "sefs" <sefsinc@xxxxxxxxx>
Date: Thu, 7 Apr 2005 11:17:29 -0800

I have a table that consist of rows of one field.

like this

1) firstitem
2) thisitem
3) thatitem

I want to compare the values in the table against another value, and if the
any value in the table is included as part of the other value of that other
value i am comparing it against its selected.

For example

If i compare firstitme against lalalalfirstitemlalala
then the first row is added to the selected list and so on.

What is the statemnt I should use with the LIKE clause

Best regards.

.

Follow-Ups:
- Re: The like clause of sql
  - From: Ken Snell [MVP]

Prev by Date: Re: IIf statements
Next by Date: Re: sql problem
Previous by thread: What type of query?
Next by thread: Re: The like clause of sql
Index(es):
- Date
- Thread

Relevant Pages

Re: The like clause of sql
... SELECT Tablename.* ... <MS ACCESS MVP> ... > 1) firstitem ... > If i compare firstitme against lalalalfirstitemlalala ...
(microsoft.public.access.queries)
Re: The like clause of sql
... SELECT Tablename.* ... then we would be saying select all records where firstitem LIKE ... >> If i compare firstitme against lalalalfirstitemlalala ... >> then the first row is added to the selected list and so on. ...
(microsoft.public.access.queries)