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.
I am no expert on SQL, but I think it is likely that BETWEEN does not
acknowledge the wildcards.
Try: Surname between 'A' and 'Ezzzzzzzz' instead (or 'F')
(If it does, there may be a severe interpretation problem - wildcards
introduce some sort of a range themselves, so the bounds are ranges too!)
Regards,
Arjen
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
