Hi:

> Select distinct substr(ZIP,1,5) AS ZIP_CODE FROM TABLE1

Oh you misunderstood. I know this and that is how I did it.

When I was playing around with the select I just noted the returned
name of the result
field as substr and thought it an odd choice.

Thanks.

Best regards