Solved

How to evaluate a string that contains single quote when that is the  special characters used to define a string value.

Posted on 2014-07-21
3
291 Views
Last Modified: 2014-07-21
All,
I have a string that contains a single quote in it (EX:  Master's).  I need to evaluate a data item value to that string.  The problem is that the special character used to define string value is the single quote (').  Is there a way for me to evaluate this string as is without having to temporarily strip out the character to do the evaluation.  If not what is the simplest way to do the evaluation?  Thanks.

Ken
0
Comment
Question by:ktQueBIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
Randy Poole earned 500 total points
ID: 40209664
just double the '' as in 'Master''s' when evaluating it
0
 

Author Comment

by:ktQueBIT
ID: 40209721
Randy.  Thanks I think I tried every combination except that one.   You just saved me some major aggravation!!
0
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40209725
No problem :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
How to increase the row limit in Jasper Server.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question