Using single quotes within a string

[allyeric]

Hi!

I am trying to insert a string from a textbox into my database. It works great, until it sees a SINGLE OR DOUBLE QUOTE in the string. The information from the textbox is a description field, and often the user will enter single quotes and double quotes to represent feet and inches. When the insert is called, there is an error ... of course. Is there any way to bypass this?

This is how the statement is being sent:

INSERT into catregistration values (100020, 'automatic spray gun, 5' long', 517)

Any help with this will be greatly appreciated!

Thanks
Ally

[sig][/sig]

 

[allyeric]

its ok .. I figured it out. In case anyone is interested, I just used the Replace function, replaced the ' with the word feet.

Description(x) = Replace(Description(x), "'", " feet&quot

Ally
[sig][/sig]