Subject Re: [ib-support] Name of Returned Field
Author Robert F. Tulloch

> 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.


Best regards