Home > Database Management > Insertion of single quotes (') as string value in MS Access Database

Insertion of single quotes (') as string value in MS Access Database



While updating a string value with single quote (') in access datbase some of the data's gets truncated? For example:

insert into testtable values( 'Ram's', 25, 'IServ' );



Above said query, updates only the following value: R,25,IServ

    
Guest


quotes within a string need to be coded as two consecutive quotes


Code:


insert into testtable values( 'Ram''s', 25, 'IServ' )



Was this answer helpful ? Yes No   
Guest
 
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2010 by Infoqu. All rights reserved