SQL question

[Ruslan Zasukhin]

On 5/23/04 12:44 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian, 

> Hi folks!
> 
> What's wrong with the following expression?
> 
> -- "SELECT
> KD_ID,RecID,newDate,lastDate,name,vorname,strasse1,plz,ort,geburtsdatum,
> mobilnummer,geschlecht,eMail,strasse2 FROM KUNDENtable WHERE (vorname_ai >=
> 389 AND vorname_ai <= 657 AND LEFT(vorname,1) LIKE 'f') AND (name_ai >= 905
> AND name_ai <= 1173 AND LEFT(name,1) LIKE 'b') ORDER BY name,vorname"
> error 616
> error 616
> error 616
> 
> 
> When I replace the "LIKE" by "=" all is fine...


1) Valentina 1.x do not allow expressions in the WHERE

2) you do 

        LEFT(vorname,1) LIKE 'f'

  this is expression.


3) only allowed exception is

    LEFT(vorname,1) = 'f'


To get indexed search that START WITH


> -- "SELECT
> KD_ID,RecID,newDate,lastDate,name,vorname,strasse1,plz,ort,geburtsdatum,
> mobilnummer,geschlecht,eMail,strasse2 FROM KUNDENtable WHERE (vorname_ai >=
> 389 AND vorname_ai <= 657 AND LEFT(vorname,1) = 'f') AND (name_ai >= 905 AND
> name_ai <= 1173 AND LEFT(name,1) = 'b') ORDER BY name,vorname"

-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------