471,092 Members | 1,498 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

how to insert a quote char

How to insert a quote char?

create table T (name varchar(10));

In T we want to insert the following string of 3 chars

ab'

insert into T(name)
values('ab'');

Oops. That's syntax error.

Out of curiosity, how is it in ANSISql and other databases?
Jul 20 '05 #1
2 1307
Siemel Naran wrote:
How to insert a quote char?


values('ab''');

or

values('ab\'');
Jul 20 '05 #2
Siemel Naran wrote:
How to insert a quote char?


values('ab''');

or

values('ab\'');
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Victor M. | last post: by
7 posts views Thread by tano | last post: by
9 posts views Thread by anachronic_individual | last post: by
7 posts views Thread by annecarterfredi | last post: by
5 posts views Thread by Rob | last post: by
1 post views Thread by Jim | last post: by
1 post views Thread by Anoop | last post: by
2 posts views Thread by lenygold via DBMonster.com | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.