Re: comparing strings in a query??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 05:50:32 -0400

Sorry, but comparisons are very literal. As you say, you're telling it to
look for pkg., and those four characters do not appear in what you're
searching, so there's no way you're going to be able to find it.

If you said to look for pkg (without the period), then

WHERE TextField Like "*pkg*"

would work. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ivan Debono" <ivanmdeb@hotmail.com> wrote in message
news:%23bCZI1MvEHA.1524@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I need to compare strings in a query.
>
> I have a table where one text field contains, for example: 'package,pkgs.'
>
> My criteria (string to compare) is 'pkg.' (notice the dot after pkg!!)
> Although my whole string is not found within the text field, 'pkg' matches
> with the first 3 letters of 'pkgs'.
>
> So how will my where clause be, if this is possible???
>
> Thanks,
> Ivan
>
>

Relevant Pages

  • Re: comparing strings in a query??
    ... Yeah that's my problem. ... > look for pkg., and those four characters do not appear in what you're ... >> I need to compare strings in a query. ...
    (microsoft.public.access.queries)
  • comparing strings in a query??
    ... I need to compare strings in a query. ... Although my whole string is not found within the text field, 'pkg' matches ... So how will my where clause be, ...
    (microsoft.public.access.queries)
  • Re: Dynamic dhcp and bind update
    ... I know but I was searching for a pkg. ... which is dhcp v.3 ...
    (comp.unix.bsd.openbsd.misc)