Use of ' in a field value

[Sashanan]

I recently found that, since SQL uses single quotes (') to mark text fields, problems arise when a ' is in that field. Is there any way to save a single quote (among different characters) in a text field without confusing SQL? I'm using MS SQL Server 7.0, in case it makes a difference.

Thnx in advance!


Example of non-functional query:

INSERT INTO Company(com_name)
VALUES ('Danny's Pizza')

 

[cdukes]

Please refer to FAQ entitled

How to Query Strings

Hope this helps,

Chris Dukes

 

[MikeLacey]

link to that FAQ is faq220-109
Mike
michael.j.lacey@ntlworld.com

 

[Sashanan]

Yeah, I had found it. Now to figure out the proper VB routine to convert ' to '', but I should be able to do that.

Thnx to you both!
"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)