This might be easier than I'm making it, and it's not helping that I just confused things by writing the "left most characters". Sorry about that.
I have a field called zipcode. We'd like to trim the data in that field, for every record in the DB, to have no more than 5 characters. Preferably, the first five.
Would be trimmed down to: 12345
Apologies if I wasn't clear before!