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.