[242] in Tooltime
RE: %'s in searches and how to get rid of them
daemon@ATHENA.MIT.EDU (Lynne E. Sousa)
Thu Sep 12 09:00:35 1996
Date: Thu, 12 Sep 1996 08:58:30 -0400
To: tooltime@MIT.EDU
From: "Lynne E. Sousa" <sousa@MIT.EDU>
>From: Terry Arnett <tarnett@scopus.com>
>To: "'Lynne E. Sousa'" <sousa@MIT.EDU>
>Subject: RE: %'s in searches and how to get rid of them
>Date: Tue, 30 Jul 96 19:38:00 PDT
>Encoding: 46 TEXT, 50 UUENCODE
>X-Ms-Attachment: WINMAIL.DAT 1978 00-00-1980 00:00
>
>
>Hi Lynne
>
>It's good to hear from you. Chicago is nice, cool weather, and good
>location.
>
>The % signs were appended to the search string in order to use the LIKE
>predicate in the search. If you remove the % signs, you will have to have
>the user type in the * sign after they enter the value (i.e.
>
> lastname*
>
>Then you will have to change the select clause and replace the LIKE phase
>with =
>
>This will be a training issue for your users.
>
>If you need to talk, give me a page at 1-800-796-6595.
>
>Hope Steve has talked John Howe in to letting me come back.
>
>Terry
>
> ----------
>From: Lynne E Sousa[SMTP:sousa@MIT.EDU]
>Sent: Tuesday, July 30, 1996 3:20 PM
>To: tarnett
>Cc: sousa
>Subject: %'s in searches and how to get rid of them
>
>Hi Terry!!
>
>How is Chicago? we are progressing nicely here in Boston. I have a
>quick
>question. When you set up our search of the warehouse data for the
>personal
>information you append % signs. How do I get rid of them? I have tried
>commenting out the append val %, but then the searches fail.
>I have tried string trim $val % but that does nothing. I am at a total
>loss
>if you could help I would appreciate it.
>
>Lynne E. Sousa
>sousa@mit.edu
>(617) 258-5857
>
>
>The following binary file has been uuencoded to ensure successful
>transmission. Use UUDECODE to extract.
>
>
>Attachment Converted: c:\eudora\attach\WINMAIL.DAT
>
Lynne E. Sousa
Computing Help Desk
11-226A
8-5857
