如何在SQL Server中选择前100个字符?

I want to truncate a column to a max of 100 characters. How do you do this in SQL Server?I want to truncate a column to a max of 100 cha