Pattern maching question

How can I get all the contacts which start with numbers? PLEASE NOTE: contact_name is a character field.

select contact_name from contact
where contact_name like '[0-9]%'

does not work (like other dbms...)

My workaround is;

select contact_name from contact
where contact_name < 'A'

but I want to know the proper syntax for the first query. Received on Mon Sep 18 2000 - 16:39:10 CDT