Re: Forms 3: query with non-numeric in number fields
From: wareing pti <p0070621_at_brookes.ac.uk>
Date: 20 Jul 1994 15:33:14 +0100
Message-ID: <30jcja$s3l_at_cs3.brookes.ac.uk>
Date: 20 Jul 1994 15:33:14 +0100
Message-ID: <30jcja$s3l_at_cs3.brookes.ac.uk>
rjscho_at_skcla.monsanto.com wrote:
> Excuse my ignorance.
'Salright
> I thought the % was only valid in a query on a character field. Does the above
> example mean any value beginning with 13 even in a number field???
> Would the responses be 13, 130, 131...139, 1301, 1302, etc. ?????
Yes. Note that this is done as a character comparison, so indexes can't be used.
> Thanks in advance for your patient replies.
It was simple enough.
> Bob
-- Tommy Wareing Oxford Brookes University 0865-483389Received on Wed Jul 20 1994 - 16:33:14 CEST