* Craig Shepherd
select * from consumers surname BETWEEN '$surname_from' AND '$surname_to'
assume $surname_from = A and $surname_to = B
would only return results where the surname is A or greater but
less than B, but I would like to include all records where records
also start with B.
]
Subject: RE: BETWEEN... LIKE query
* Craig Shepherd
select * from consumers surname BETWEEN '$surname_from' AND
'$surname_to'
assume $surname_from = A and $surname_to = B
would only return results where the surname is A or greater but
less than B, but I would like to include all
Why you don't try:
BETWEEN '$surname_from' AND concat($surname_to,'z') ?
Makis
-Original Message-
From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 1:30 PM
To: [EMAIL PROTECTED]
Subject: BETWEEN... LIKE query
Hi,
I have a form with two fields