Truncate characters in a column

[rmiao]

Can try:

update table set zipcode = convert(char(5), longzipcode)

or

update table set zipcode = substring(longzipcode, 1, 5)