help me for this query

[svijayakumaris]

Hi,
I want to store the text data with apostrophe in the table.
I tried through this query like this
insert into temp values(101,'vijaya\'s');

but it is giving error - missing comma

Could anybody help this sql query for the following requirement?

NAME
vijaya's
rajani's

[debasisdas]

try this sample query

insert into temp values(101,'vijaya''s');

hope that solves your problem.

[svijayakumaris]

Thank you. It's working.

[debasisdas]

You are most welcome.
I am glad to know i could help you.

[svijayakumaris]

You are most welcome.
I am glad to know i could help you.

Thankyou! its working.

[svijayakumaris]

You are most welcome.
I am glad to know i could help you.

Thankyou! its working.

-vijaya