Re: Like Expression in IDC Query

Dale E. Reed Jr. ( (no email) )
Wed, 24 Dec 1997 09:54:13 -0800

Jeff Cummings wrote:
> I know that this really isn't the type of question to post here, but I do
> know that there are other Emerald Administrators using Web and IDC files.
> I'm trying to do a SELECT against a DataBase and use a LIKE expression from
> an IDC file on a Web Page.
> I can make it work with a straight WHERE field = '%variable%' but I can't
> figure out the proper quoting for the like in the Query. I can do it find
> in a stright query, though.

I'm guessing (since I have nver touched IDC), but try:

Where Field like '%%%variable%'

If IDC is like any othe language, the first two %% will give you
a single percent (the wild card in SQL) and then the variable.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |