I have a text field that is seven characters wide. Data may occupy all seven or just a part. If it is only a part, it occupies the end. So that if 0003201 is stored, it takes all seven spaces, but if 3201 is stored the first three spaces are blank.
How do I filter for that? I cannot enter blanks in front of the 3201 because the filter eliminates those immediately. I can just enter 3201 and hope for the best, but the best has so far not shown up. I tried putting ' around the 3201 with three blanks such as ' 3201' but that doesn't work because the report writer automatically only allows the seven characters and '0003201' is nine long.
What is the correct way to do this?
Thanks,
Hans
The interesting thing is that FoxFire! does appear to accept the starting spaces before 3201 when entered in the filter even if the filter doesn't show it and when editing the filter the spaces are gone at the input. The SQL statement does show it as ' 3201'.
Working with it some more, I've found that just editing the SQL statement and saving it is also sufficient to get this to work.
>>Left these comments in case someone else has this problem, but it is not a problem for me anymore.<<
Sent. Thanks.