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

how to do wildcard (*) search for numeric field

1189 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.