|
View previous topic :: View next topic
|
| Author |
Message |
suresh_gop1
Warnings : 1
New User
Joined: 23 May 2006
Posts: 18
|
|
|
|
Hi,
How to insert char O 'CONNELL? i tried as insert into table name values ('O 'CONNELL'). but it returns error. how to correct it. |
|
| Back to top |
|
 |
Manuneedhi K
Active User
Joined: 07 May 2008
Posts: 115
Location: Chennai
|
|
|
|
Whenever you want to insert a single quote you must use two single quotes .
(i.e) To insert O'Connell you must use 'O''Connell' in the values of the insert. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| suresh_gop1 wrote: |
Hi,
How to insert char O 'CONNELL? i tried as insert into table name values ('O 'CONNELL'). but it returns error. how to correct it. |
It would have nice if you had provided the error information.
try 'o ''connell' |
|
| Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 165
Location: Bangalore
|
|
|
|
| you may use the escape character as well... |
|
| Back to top |
|
|
|
|
