Thanks. This puts the finishing touches on my Knowledge Base.
Hopy you and the reset of the list members have a Merry Christmas and Happy New Year.
Jeff
On Wednesday, December 24, 1997 9:54 AM, Dale E. Reed Jr. [SMTP:daler@iea.com] wrote:
> 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
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>