Pattern matching ints

Hi,

Is there a more efficient way to pattern match integer columns other
than something like :

where cast(mynumber as text) ~ '.*123.*'


I also seem to recall you can't create indexes on casts either ?


Thx

Tim