Category "patindex"

SQL Server : finding substring using PATINDEX function

I'm writing different queries in SQL Server. I have 2 tables, Employees and Departments. Table Employees consists of EMPLOYEE_ID, ENAME, ID_DEP - department id.