Search brings up additional content

[Robert Adams]

Hello,

I have a column with numbers, three of these numbers are 475 and 4750 and 0475.

My field I use for a user to fill out uses javascript to trim the input of blank spaces so when a user searches for 475 , 475 comes up but also included is 4750 and 0475.

Is there a way to search and not have items that are similar, like 4750 and 0475, be included?

My search term is below:

WHERE%20C%20CONTAINS%20%27475%27 (encoded)

WHERE C CONTAINS '475' (not encoded)

Thank you,

Robert