Subject Re: [firebird-support] Wildcard for Firebird
Author Leonardo Nakahara de Oliveira
I'm using the Firebird-1.5.2.4731-Win32 and the .Net Provider is the
FirebirdNETProvider-1.6.3-NET1.1.exe.


Leyne, Sean wrote:

>
>
>>------------------------------------------------
>> select * from COUNTRY where NAME like '<something>%' or
>> select * from COUNTRY where NAME like '<something>' || '%'
>>
>> Both ways show me the following error:
>> Dynamic SQL Error
>> SQL error code = -104
>> Token unknown - line 1, char 45
>> %
>>
>>
>
>Try,
>
>select * from COUNTRY where NAME like ('<something>' || '%')
>
>
>By the way, what version are you using.
>
>
>Sean
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>