How effective is my Field

[amerifax]

I have a table with thousands of records. I'm getting ready to create new tables. My field in one case is Char 18. I would like to see if I'm filling the field using all 18 characters. Also weather I only have less than 100 that require all fields. If I could do a sort of some kind that would give me perfect viewing of the field.
Bob

 

[jdraw]

Please tell us more about the application and what exactly this means
a sort of some kind that would give me perfect viewing of the field

 

[amerifax]

>>jdraw<<
>>Pat Hartman<<

A standard sort could be C14. Field would be character of 14.

Example:
Bob
Robert
Robert Snow

If all were the size of Bob I would be wasting a lot of size on my drive. Robert Snow is just short of 14 by 2 so is not that bad.

Problem is my table is 4000,000 records and 1 wasted space is a lot.

I need to be able to view some kind of a sort. I was hoping for some kind of a filter that could be applied but this might be a better solution. I will try it tonight Pat.

Bob

 

[amerifax]

Thank you very much. The code worked great. Anyone who has to process data or work with large databases could really use a code snippet such as this!!

Thanks so much for your help!!!

Bob