Roger wrote:
On Wed, 2006-08-30 at 12:03 +0100, Martin Jenkins wrote:
Roger wrote:
I have a question.
I trying to write a query as follows
Select *
From People
Where Surname Between 'A%' and 'E%'
Order by UPPER(Surname);
Now the problem i have is that i get only the Surnames from A up to D
and the E's are excluded.
Can anyone help me out, i am writing a web based application.
How about:
Select *
From People
Where Surname Between 'A%' and 'F%' ' <--- s/E/F/
Order by UPPER(Surname);
Thanks for the response guys but then my problem comes when i try and
query a range between T and Z i tried to make it query between T to A
but got no result. Anyway i will have to add a constraint in my PHP code
for T to Z.
Well, the character after 'Z' is 'a' in the ASCII table. You could try:
BETWEEN 'Z' and 'a'
Regards,
Arjen
