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
So no search results you'll get dissapointing results.
I can't revert to Number since sometimes, letters are used aswell :
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 ?