Skip to Content
0
Former Member
Sep 13, 2007 at 11:43 PM

I hit a wall

34 Views

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