Post Author: hd1
CA Forum: General
I remember posting this problem last time but now I finaly realized the root of the problem. I'll try to explain this the best I can.....I have a field in my database table called "Value." This field I feel wasn't created good. I don't know if it was the program that is writing to the database or the person who created it. This field contains various dates in the format of 1900-01-01 to present time. The field also contains various double digit numbers in the format of 50, as well as telephone numbers 555-555-5555 and names John Smith. I know, that's not good. So I'm stuck with this problem. The user wants to be able to sort by name such as John Smith. The only problem is when I set up a parameter for "John Smith," that is only thing being displayed because it is filtering everything else out. I don't know if there is a way to exclude all names but include everything else in the database. I don't want to use the not ["John Smith", "John Doe",] then they just won't show up.
Thanks!
Brian