Avatar of Aleks
Flag for United States of America

asked on 

truncate field to 8000 characters

I am changing a field from text field to varchar(8000), there are one or two records with more than 8000 characters.
How can I truncate them so that I can run the conversion ?

the table name is: employment
the field is: jobdesc
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon