Subject please help, sql statement
Author Olaf Kluge
Hello,

I've an urgent problem. An query from another tool like this:

SELECT TARBG.TEILENR, UCase([ARBEitsgang]) AS ARbG, TARBG.STG100 AS Alt,
[stg100]/83.3*83 AS Kohl,
FROM TARBG
WHERE (((UCase([ARBEitsgang])) Like nz("*" & "SCHWEI├čEN" & "*","*")));

For firebird I have thougt this translation:

SELECT TARBG.TEILENR, upper(tarbg.ARBEitsgang) AS ARbG, TARBG.STG100 AS Alt,
tarbg.stg100/83.3*83 AS Kohl
FROM TARBG WHERE Upper(tarbg.ARBEitsgang) Like ('*' || 'SCHWEI├čEN' || '*')

How can I integrate this '*' placeholder? How does it works with firebird?
(The other statement works in microsoft access linked with firebird-Tables.



[Non-text portions of this message have been removed]