select * from iac_asn_header where to_char(asn_header_id) like '%1' select * from iac_asn_header where cast(asn_header_id AS varchar(10)) like '%1'