topic Re: Using a name with an embedded single quote in a select statement in QlikView

Using a name with an embedded single quote in a select statement

Thu, 05 Dec 2013 17:09:56 GMT

I want to use a query like this one below

SELECT
     Employee_Id, Work_Email, Department,City,Job_Title,Reports_To
FROM
     Employee
WHERE
   EmployeeName = 'Firstname O'Lastname'

I've tried combinations of using single and double quotes, using [] and also trying to use CHR(39) but nothing seems to get this to work properly....what do I do if the name has an embedded single quote?

Re: Using a name with an embedded single quote in a select statement

rwunderlich — Thu, 05 Dec 2013 17:11:26 GMT

What brand of database is this query going to?

Re: Using a name with an embedded single quote in a select statement

Thu, 05 Dec 2013 17:16:59 GMT

Its a SQL server database

Re: Using a name with an embedded single quote in a select statement

Gysbert_Wassenaar — Thu, 05 Dec 2013 17:18:59 GMT

You can escape the single quote with another single quote: EmployeeName = 'Firstname O''Lastname'

Re: Using a name with an embedded single quote in a select statement

Fri, 06 Dec 2013 22:42:50 GMT

Thanks...that worked.

I had thought I had tried all the possible combinations.