Hi:

Select distinct substr(ZIP,1,5)

returns a field named substr with all the values.

This is really stupid.