AnsweredAssumed Answered

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

Question asked by tony.dhoop@telenet.be on Mar 2, 2014
Latest reply on Mar 3, 2014 by hbrendel

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

Outcomes