==========================================================

IDE: VS2005 Pro

Technologies: MS ACCESS, VB.NET

==========================================================

Is there a restriction against using brackets in an SQL query?

Such as inserting a text string:

INSERT INTO SB_ACTIONS (ACTION_PLAN, ACTION_CODE,UID) VALUES('(To extend fabrication by 5 [providing proper instruction])', 325, 4567685)

I understand that some LIKE queries use the brackets in place of percent signs or astericks. Is this causing the issue?

Is there a way around this, such as using double-single-quotes ( '' ) to prevent SQL injection, so that I may allow users to enter a string that includes brackets?

Your help is greatly appreciated,

KJAK

Okay. I have spoken to a few database administrators. They couldn't think of any reason why this wouldn't work.

I went through and repeatedly debugged this issue. I finally noticed that it was an extra apostrophe that was being tacked onto the SQL statement. A stupid mistake. I found where that was being added and corrected it. I don't expect there to be any more issues with this.

Thanks for all who looked and tried to help!

KJAK

Okay. I have spoken to a few database administrators. They couldn't think of any reason why this wouldn't work.

I went through and repeatedly debugged this issue. I finally noticed that it was an extra apostrophe that was being tacked onto the SQL statement. A stupid mistake. I found where that was being added and corrected it. I don't expect there to be any more issues with this.

Thanks for all who looked and tried to help!

KJAK