Dealing with single Quote in SQL Query
Hi Guys
how do I deal with single Quote inside string in an SQL query?
currently this type of query is failing with an error asking me for a closing quote :
Select * from cnd.Facilities where name like ''%Grill's BBQ%'
Thanks
Product version: Caché 2014.1