Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

quote in quote

Posted on 1997-06-11
1
Medium Priority
?
300 Views
Last Modified: 2010-04-06
Hi

I need to be able to build a string that equals

Select trade_close from trade where trade_date = '1995-05-09'

the above date has to be inside a pair of '

when I go g := ' Select trade_close from trade where trade_date = '1995-05-09' ' it does'nt work

How do I get a quote char inside a string

Thanks

Chris
0
Comment
Question by:chrisj051697
1 Comment
 
LVL 1

Accepted Solution

by:
ygolan earned 200 total points
ID: 1336975
Use the quote character twice :

'Select .... where trade_date = ''1995-05-09'''

Note that the string ends with _3_ quotes - 2 for the actual quote and one to end the string.


0

Featured Post

Industry Leaders: 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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

824 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