Re: Quick SQL Question
"Booth, Bill" <[email protected]>
| Newsgroups | gmane.comp.windows.devel.dotnet.winforms |
|---|---|
| Message-ID | <[email protected]> |
That is what he says. If he wants an exclusive range he should try < and >. -----Original Message----- From: Discussion forum for developers using Windows Forms to build apps and controls [mailto:[email protected]] On Behalf Of Ryan Heath Sent: Wednesday, May 16, 2007 03:07 To: [email protected] Subject: Re: [DOTNET-WINFORMS] Quick SQL Question Hello Steve, You wrote > Where @SuppliedHouseNumber between LowAddress and HighAddress > > For the value of @SuppliedHouseNumber='700' the query returns the > following two records > 1) LowAddress = 700 , highAddress = 700 which of course is expected, > 2) LowAddress = 700 , highAddress = 718 which of course is NOT > Expected but I don't know why. But 700 *is* between 700 and 718, that *should* be expected ... // Ryan The information in this e-mail is confidential, may be legally privileged and is intended solely for the addressee. If you have received this e-mail in error, you are hereby notified that any use, distribution, or copying of this communication is strictly prohibited.