Problem with insert statement

Hi,

I would like to insert a string having ' charactor.
I am getting problem because of this
can any body help me ....
its verry urgent....

Thanks

Regards
Bhushan

When you are using ' on purpose, I think that you are asking for problems. Why don't you use " or ` instead?

The single quote must be entered twice inside a quoted string:
Insert . . . Values('O''Neal', . . . . .)

I would recommend using a bind variable in the insert statement. and that bnd variable can contain any value.

thanks everybody........