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. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com