How to compare the mask field values?

Hi,

For my program I will get input no as 45XXXXXX234(like mask no)

and i need to compare this no in table(table also havinig the numbers same way 45XXXXXX234 with masking, I want to get this record by matching with input)

but when I am giving select statement using my input its not able to match the record in the table.

for masking field values how to compare the values?

thanks for ur time.

Kiran.