November 16, 2017 at 9:46 am
,SUM (CASE WHEN Q2.CSISeqNo = 185 AND A.Description = 'Loan Cars - C&D's Not Suitable' AND Q.Answer = 6
THEN 1 ELSE 0 END) AS [Parts ordering process]
Guys, how do I get around the above, i'm assuming I am getting an error message due to the - and ' within the 'Loan Cars - C&D'
s Not Suitable'
November 16, 2017 at 9:56 am
craig.jenkins - Thursday, November 16, 2017 9:46 AM,SUM (CASE WHEN Q2.CSISeqNo = 185 AND A.Description = 'Loan Cars - C&D's Not Suitable' AND Q.Answer = 6
THEN 1 ELSE 0 END) AS [Parts ordering process]
Guys, how do I get around the above, i'm assuming I am getting an error message due to the - and ' within the 'Loan Cars - C&D'
s Not Suitable'
Just escape the quote after the D by doubling it:CASE
WHEN Q2.CSISeqNo = 185 AND A.Description = 'Loan Cars - C&D''s Not Suitable' AND Q.Answer = 6 THEN 1
ELSE 0
END
John
November 16, 2017 at 9:59 am
It's standard practice in many programming languages that if you need to include the string delimiter inside a string to use a double delimiter. So, you just need to double the single quote in your 'C&D''s'
,SUM (CASE WHEN Q2.CSISeqNo = 185 AND A.Description = 'Loan Cars - C&D''s Not Suitable' AND Q.Answer = 6
THEN 1 ELSE 0 END) AS [Parts ordering process]
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
November 16, 2017 at 11:34 am
If you're building these queries dynamically, " QUOTENAME(Description, '''') " puts quotes around a string and doubles any embedded quotes. Or " QUOTENAME(Description, CHAR(39)) " if you don't like the four-apostrophe literal.
The downside is that it only accepts 128-character values.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy