Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Apr 29, 2002

Handling Single Quotes in a SQL Query


To insert data with single quotes, place 2 single quotes instead of 1 single quote, like this:
 
create table MyTable (
    Field1 varchar(10)
)
go
insert MyTable (Field1)
    select 'A1111''1111' UNION ALL
    select 'F''66666666'

In the same way, you can retrieve data by using 2 single quotes. For example:
 
select * from Mytable where field1='F''66666666'
select * from Mytable where field1='A1111''1111'
drop table mytable
NageswaraRao Kurra
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date