SQL Query trouble

[Ruslan Zasukhin]

on 1/21/03 11:17 PM, Peter De Berdt at peter.de.berdt at pandora.be wrote:

Hi Peter,

> I was able to clear all problems except one: I'd like to get all
> companies starting with letters from A to P for example, I thought
> the following would work:
> 
> SELECT * FROM People WHERE Company BETWEEN 'A' AND 'P'
> 
> But this doesn't return any results.

Yes, at first BETWEEN is not implemented yet.

You need simply use AND

    WHERE 'A' <= Company  AND Company  <= 'P'


> How do I query my db for ranges of letters (I searched some RegEx
> docs, but I couldn't find anything)? And this has to be case
> insensitive also.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------