By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE #employee(ID INT IDENTITY(1,1), EmployeeName NVARCHAR(100));
INSERT INTO #employee VALUES (N'waidаnde');
SELECT *
FROM #employee
WHERE EmployeeName LIKE '%waidande%';
SELECT *
FROM #employee
WHERE CAST(EmployeeName AS VARCHAR(100)) <> EmployeeName;
| ID | EmployeeName |
|---|
| ID | EmployeeName |
|---|---|
| 1 | waidаnde |