changing zip-code format

[pooja]

we have zip code  field on db(db2)  with format 750650000(varchar)
my concern is how to display only the first 5 no --without last four 0000.

any help kindly apprerciated


pj

[lindero]

what about cutting the trailing characters as "substring(zip_code,1,5)"

[pooja]

thank you 'lindero'

i appreciate

pj