select a range of data

If I have a column with a value like "abc2457", "efg1234",

how do I select col from table where col like 'a[a-z]c24[0-9]7"?

How do I handle the range bracket in the query?

Thanks.

---

Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.