Subject | Re: [firebird-support] Wildcard for Firebird |
---|---|
Author | Leonardo Nakahara de Oliveira |
Post date | 2005-01-21T18:29:46Z |
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:
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
>
>
>
>
>
>
>
>
>
>