5 Replies Latest reply on Mar 3, 2014 2:38 AM by hbrendel

    looking up data without having to worry about spaces, periods, dashes, etc...

    tony.dhoop@telenet.be

      in a database, data is entered in a specific way by each user.

       

      eg. people can either enter a product reference as :

      10 13 4521

      10134521

      10.13.4521

      10-13-4521

       

      So no search results you'll get dissapointing results.

      I can't revert to Number since sometimes, letters are used aswell :

      102a 556c

      102.a.556.c

      102a/556c

       

      Since many users use the database, many input mehtods are used.

      Trying to discipline the people in data entry has helped, but hasn't given 100% security.

       

      Can anybody give me advice on how to handle this ?

      Thanks

      Tony