Solved

quote in quote

Posted on 1997-06-11
1
278 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 100 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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