Re: help newbie question!

From: John Leggitt <johnml_at_istar.ca>
Date: 1998/03/30
Message-ID: <ccFT.68$b$4.692649@NewsRead.Toronto.iSTAR.net>#1/1

Use:

SELECT * FROM tablename
WHERE columnname LIKE '%var_%';

% is a wild card representing 0 or more characters. _ is a wild card representing 1 and only 1 character var is any literal value. % and _ are optional but usually one or both are used.

JohnL

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!?
Received on Mon Mar 30 1998 - 00:00:00 CST