How to fetch the grid result by removing "- "

Question

HI All, 
 
 while case creation user will add policy number like this 12345675-7896 but when storing to DB will remove the "-" and will store only 123456757896 
 
 but while in the home page user filtering the record using 12345675-7896 the results will display null

Could you please suggest me the better solution. 
 Thanks in advance.

Mathieu Drouin · Answer

Possible you're saving it in an integer field? 
 If you want to keep the dash, I would suggest changing it to a Text field. 
 If you can't do that, another option would be creating a custom text Record field that inserts the dash at that position and change the column and search filter to point to that new field.

Mike Schmitt · Answer

Are you saying the DB field can only contain numbers? Because if that's how it works, then it should be pretty easy to take the user's filter input and remove anything non-numeric before passing it to the query.

Mike Schmitt · Answer

Are you required to use the Record Search Box? Because with a manually-defined search box, this would be trivially easy to handle. I'm not sure how you'd handle it using the Record Search, though i suppose there might still be a work-around I'm not thinking of.