Criteria with verifying the first 3 characters of a text

Criteria with verifying the first 3 characters of a text - how

microsoft.public.access.gettingstarted

23 Feb 2005 8:10 AM

Rene Wennekes

I want to make a querie with a criteria to filter out only the records with
text what begins with "192".

How do I do that?

Rene

23 Feb 2005 10:11 AM

rico

Like this:

SELECT field1, field2, field3
FROM yourtable
WHERE field1 LIKE '192%';

HTH

Rico

Show quote

"Rene Wennekes" wrote:

> I want to make a querie with a criteria to filter out only the records with
> text what begins with "192".
>
> How do I do that?
>
> Rene
>
>
>

23 Feb 2005 5:16 PM

fredg

On Wed, 23 Feb 2005 09:10:20 +0100, Rene Wennekes wrote:

> I want to make a querie with a criteria to filter out only the records with
> text what begins with "192".
>
> How do I do that?
>
> Rene

Where Left([YourTable].[FieldName],3) = "192"

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.