Insert question.

I'm sending a command to SQL Server:
Insert into table1 (aaa) values ('bbb')
it works fune but what if I wish to incert value b'bb?
Insert into table1 (aaa) values ('b'bb') causes an error.
What do I have to change in that command?> it works fune but what if I wish to incert value b'bb?
> Insert into table1 (aaa) values ('b'bb') causes an error.
You have to escape the apostrophe with doubling it:
Insert into table1 (aaa) values ('b''bb')
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/