Like-query as number

[Raminder]

You can remove the '%' sign from queries and convert rest of the varchar string to number

select to_number('000037') from dual
/

gives you 37.

So you can use:

select * from table_a where col1 like to_number(rtrim('000037%','%'))

[Edited by Raminder on 10-10-2001 at 06:27 AM]