Jeff Moden (3/24/2009)

---

Chirag (3/23/2009)

---

Jeff

select substring('1230-544',number,1)

from number where number <= len('1230-544')

and substring('1230-544',number,1) like '[%0-9%]'

Also, your query doesn't put it all back together like the op wanted and you don't need the % signs in the like because you're looking at a single character.