db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald McLean" <dmclea...@gmail.com>
Subject Re: Portability issue for 'Like-clause' on non-string types ?
Date Thu, 26 Jun 2008 12:18:38 GMT
I'm guessing that it wants a string type. You will probably have to
use a CAST. I'm not sure of the exact syntax, but I think that it
might look something like this:

select cast(sc.id as varchar) as sc_id from sms_command sc where sc_id like "%"

On Thu, Jun 26, 2008 at 12:42 AM, Albert Kam <moonblade.wolf@gmail.com> wrote:
>
> ij> select sc.id from sms_command sc where sc.id like '%';
> ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having
> compatible arguments was found.

Donald

Mime
View raw message