| replace single quote [message #371576] |
Thu, 09 November 2000 07:44  |
SRINIVASU
Messages: 2
Registered: November 2000
|
Junior Member |
|
|
Thank u for u r valuble information
but i have one more doubt
that is
i want to insert a string like " this is srinu's book"
into a table
i gave here small string but i have a long string with so many sigle quotes in that string
How can i insert
i wrote like hear
insert into xyz values(1,'this is srinu's book') and also try with
insert into xyz values(1,replace('this is srinu's book',chr(39),'''')
i did'nt get result
Please respond me
thank u
|
|
|
|
| Re: replace single quote [message #371578 is a reply to message #371576] |
Thu, 09 November 2000 08:15  |
Babu Paul
Messages: 38
Registered: November 2000
|
Member |
|
|
Hi
The value in the insert statement is wrong.
Try this!
It should be
insert into xyz values(1,'This is srinu'\'s book') ;
insert into xyz values(1,'This is srinu'||CHR(39)||'s book') ;
Good Luck!
Babu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
