Hi:

I am trying to run a simple sql query with a like clause but it fails. The query is as listed below:

select * from sam.change where start_date like '1%'

the query fails with the following error:

select * from sam.change where start_date like '1%'
SQL0440N No authorized routine named "LIKE" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884

Can someone help here.... asap

thanks

samit

Like only works with strings. I am certain that start_date is DATE.

Andy

if this is the case : try char(start_date) like '1%'
or use date function : year.... and between

Yes i tried working on it yesterday and came up with the solution to use

char (column_name) like '2%'

Thanks.

Samit