SQL question

[Florian Bogeschdorfer]

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...

-- "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"


TIA, Florian