Even with the

select * from COUNTRY where NAME like ('something' || '%')

it returns the same error as always: Token unknown

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