It'll do
but for me
where B.EONO LIKE '[0-9]%'
looks more 'SQL like' :) and theoreticaly it could be optimazable (could use index on eono).

---

>What about this?
>substring(d.eono,1,1) between "0" and "9")

>
>>>Will it work for the first character?

>>>>Is this better?
>>>>

>>>>where B.EONO LIKE '[0-9]%'
>>>>

>>

---

>>Yes it will. Take a look at LIKE operator in SQL Server BOL.