I've got a column in SQL which has data in it that needs trunctating to 16 characters where some of it is allowed to go to 20 characters. I've had a look everywhere and I cannot find anywhere that tells me how to do an update statement to truncate the data to 16 characters. I've got a where clause that allows me to find any data that is over 16 characters but there is usually a lot of it and rather than having to manually remove the last 4 characters I was hoping that I'd be able to write an update statement that would do it for me.
The where clause is: where len([column]) > 16
I would really appreciate any help in sorting this out, thank you in advance