- Case sensitive, full half-width character
--Test Data
Create Table Table (FD VARCHAR (10))
INSERT INTO table
SELECT AA = 'aa'
Union all Select 'aa'
Union all SELECT 'AA' - Full Corner A
Union all Select 'a, a' - full angle A, half angle,
Union all Select 'a, a' - full corner A, full corner,
Go
--Inquire
--1. Check the uppercase
SELECT * FROM table
WHERE fd collate Chinese_prc_cs_as_ws like '% a%'
- is the list of collate chinese_prc_cs_as_ws after the field name
--2. Check the whole corner
SELECT * FROM table
WHERE fd collate Chinese_prc_cs_as_ws like '% a%'
--3.
SELECT * FROM table
WHERE FD Collate Chinese_PRC_CS_AS_WS LIKE '%,%'
Go
