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