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
49
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> 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
&g
* 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
