| sql problem [message #99585] |
Thu, 17 January 2002 00:57  |
vikas kumar
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
hello freind,
i have a problem in insering a data with single quotes in a varchar data type column ina table.
for eg-:suppose there is a table with following specification-;
table a
column msg varchar(20)
now i have to insert this data
vikas's
if i write insert statement like this
insert into a values('vikas's');
it gives a error and data is not inserted.
so,will you please tell me how to write the insert statement.
waiting for your reply.
vikas
|
|
|
|
| Re: sql problem [message #99588 is a reply to message #99585] |
Fri, 18 January 2002 11:56  |
-sven
Messages: 11
Registered: August 2000
|
Junior Member |
|
|
Try using two single quote marks to represent the single quote mark within the quoted string, as in:
'vika''s'
I hope this helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
