I have create an sql connection, and the sql statement in code, using a field within a database.

The problem that i am having is that the field in the database contain characters that sql uses, thus causing the statement to fall over.

Is there anyway around this, without me having to go through all 180+ sq database to look for certain characters.

The symbols that i have come across so far that cause the statement to fail are ' and "

Many thanks for any help in advance.

M8KWR