SQL DB2 LIKE statement

[kmcdona]

I'm looking for the statement that will allow a search for a range of values in a LIKE statement. For example:

I want to return all values where the is a numeric value in the string, but not first or last. Right now I'm doing:

select * from a where field LIKE '%1%' or field LIKE '%2%' or field LIKE '%3%' ....

I know there's a more efficient way of doing this, could someone help me out?

Thanks