SQL Server filter content Chinese vs English

Question

May I know is there any SQL Script to fulfill my below scenario?

If column1 contain Chinese character, update value column2 to 'Chinese'
If column1 contain English character, update value column2 to 'English'.

Answer 1

You can check column values for english using like operator.

UPDATE table1
SET col2= CASE WHEN col1 LIKE '[a-zA-Z0-9]' THEN'English'
          ELSE 'chinese' END