Quey on table

  • 12 November 2021
  • 0 replies
  • 1 view

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 replies

Be the first to reply!