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 <[EMAIL PROTECTED]> 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
