how to insert special characters like ' or & or [] ... etc
with INSERT INTO statement.
with out replacing them
Printable View
how to insert special characters like ' or & or [] ... etc
with INSERT INTO statement.
with out replacing them
Is this directly in SSMS or though a front end?
If front end the best option is to use parameterized queries. Second option is to use replace (if using concatinated SQL string) someVar.Replace"'","''")
If in SSMS then the single qoute (') needs to be two of them ('')
Assuming it is through a front end... For an explanation of why you should be using parameters (and links to code examples), see the article Why should I use Parameters instead of putting values into my SQL string? from our Database Development FAQs/Tutorials (at the top of this forum).
thank u sir
normally i work with MSaccess03
may i know what are the conflicting characters which i must
take care of please.
Do you mean that you are working manually in Access itself? ..or that you are interacting with a database from a VB program?
If it is from a VB program (to any database system), read the article I linked to.
thank u very much sir