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
what about cutting the trailing characters as "substring(zip_code,1,5)"
thank you 'lindero'
i appreciate
pj