SQL question
Ruslan Zasukhin
sunshine at public.kherson.ua
Sun May 23 14:19:44 CDT 2004
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
-------------------------------------------------------------
More information about the Valentina
mailing list