Pemdas
Novice

Quey on table

SELECT distinct [exchange_department] as Department, [exchange_division] as Division  FROM [AD_information].[dbo].[AD_Dept_div]
WHERE  exchange_department = 'ctlDepartment'

 

I'm getting the results for Division but if the Department has an apostrophe (') in it, I am getting not results for Division.

 

How do i run the query for department that has an apostrophe in its name i.e. 

0 Kudos
Reply