Mailing List Archive


Back to the month index Back to the list index
Joshua J. Kugler (jkugler@inreach.com)
Wed, 09 Apr 1997 09:32:24 -0700 

Message-Id: <3.0.1.16.19970409093224.3047387e@inreach.com>
Date: Wed, 09 Apr 1997 09:32:24 -0700
From: "Joshua J. Kugler" <jkugler@inreach.com>
Subject: Re: [mSQL] (B5) Data ranges in Lite?

>> Is it possible (possibly using LIKE and variants) to display a range of
>> data, specifically int's?
>>
>> What I mean is;
>> SELECT price FROM mydata WHERE price < 3400 AND price is > 4000
>>
>> or something like that.
>I'm not sure if I can help, but I did notice an error in your query. The
>condition would never be satisfied. If you want prices between 3400 and
>4000 the query should read:
>
>SELECT price FROM mydata WHERE price < 4000 AND price is > 3400
>
>I hope this helps,

Yeah, it would help him. But if he wanted his original query satisfied, he
would need to use an OR:

SELECT price FROM mydata WHERE (price < 3400) OR (price > 4000)

THAT query could be satisfied, eh?

j----- k-----

Joshua J. Kugler
Computer Consultant--Web Developer
jkugler@inreach.com
http://www.cwebpages.com/jkugler
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth, that Jesus Christ is LORD -- Count on it!

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!