Re: simple sql using between startnumber and endnumber not performing

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 27 Jun 2007 20:50:10 +0200
Message-ID: <f5ubgu$bid$2@news2.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Benjamin Sølberg wrote:

> I am using an sql which looks like this:
>
> select startnumber, endnumber from table where '12345678' between
> startnumber and endnumber

What is it - numbers or strings?!? If it's a number, loose the quotes. (If it's a string, I'd make you rename the columns in the design!)
>
> Does any one of you have any suggestions ?
>

Yes

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGgrFiLw8L4IAs830RAtkmAKCSRdO2Ab4yEwWHIN4FWLM4gTcUmgCfWlzb MU7zlqalHvZFFTStEVDV42o=
=ZFK7
-----END PGP SIGNATURE----- Received on Wed Jun 27 2007 - 13:50:10 CDT