Skip to Content
0
Former Member
May 04, 2007 at 07:46 AM

How to do wildcard search(*) for numeric field

105 Views

Hi,

I have a requirement that based on user input data with wildcard i have to search in database. But, the problem is the user input field is a Numeric field (PA0002-PERNR, NUMC 8). How to search in database based on the person name field with wildcard, i.e if i 'll enter 900* in person number field as input i should get all the record starts with 900.

regards

sandeep.