SELECT distinct  exchange_department] as Department, Âexchange_division] as Division  FROM OAD_information].ndbo].oAD_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.