SQL: Concat in WHERE-Klausel?

[Chaoten-Joe]

Funktioniert:

Delphi-Quellcode:

'SELECT vorname|| '+QuotedStr(' ')+ ' || name, eMail1, eMail2 
FROM Adressen 
WHERE ((eMail1 is NOT NULL) or (eMail2 is NOT NULL)) and ((vorname|| '+QuotedStr(' ')+ ' || name) = '+QuotedStr(Person.AsString)+')'

Danke!