Hello I'm trying to come up with a query that will subtract the overage from a column. I have a table that has a column sku and sometime the update has a greater amount than 15, and that the limit that we can use. So far I'm using this:

UPDATE updatepos

SET sku = left(sku, LEN(sku) - 2)

WHERE (LEN(sku) > 15)

but the over amount varies so that doesn't work all the time. How could I get it to subtract the amount that it's over 15?

Thanks for any help.