Re: Quick SQL Question
Ryan Heath <[email protected]>
| Newsgroups | gmane.comp.windows.devel.dotnet.winforms |
|---|---|
| Message-ID | <[email protected]> |
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