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%')

Milan

Dne 30.04.2010 11:28, Olaf Kluge napsal(a):

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