Hi Guys,
I have a strange problem. I have a databsse which has names, surname, etc. The names and surnames were all originally entered in uppercase, which is not really a problem except that certain records are just not found when a search is done unless you enter the keyword in UPPERCASE. The real funny part is that it seems limited to one field only i.e the surname.
An example would be:
keyword: porter
Result: Not Found
keyword: PORTER
Result: GARTH PORTER ETC.
plus all other porter's in the database
keyword:garth
Result: GARTH PORTER ETC.
plus all other porter's in the database
I tried editing the database record and even changed the case, no luck. The reord can only be found by entering the keyword in UPPERCASE.
Help please.
Thanks in advance
Greg
I have a strange problem. I have a databsse which has names, surname, etc. The names and surnames were all originally entered in uppercase, which is not really a problem except that certain records are just not found when a search is done unless you enter the keyword in UPPERCASE. The real funny part is that it seems limited to one field only i.e the surname.
An example would be:
keyword: porter
Result: Not Found
keyword: PORTER
Result: GARTH PORTER ETC.
plus all other porter's in the database
keyword:garth
Result: GARTH PORTER ETC.
plus all other porter's in the database
I tried editing the database record and even changed the case, no luck. The reord can only be found by entering the keyword in UPPERCASE.
Help please.
Thanks in advance
Greg