On Fri, Apr 30, 2010 at 2:58 PM, Olaf Kluge <olaf.kluge@...> wrote:

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



--
Regards,
Lt Col (Retd) Rajiv Dular Singh Chauhan
09601704890
0265-2637655
_____________________________


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