Quotes

A quote in your SQL statement may cause errors
Example: UPDATE Personnel SET lname='O'hara'

The ' in O'hara will cause the SQL Statement to error
Replace the ' with ''
Like so: lname=replace(lname, "'", "''")




Come learn HTML or Classic ASP in Honolulu, Hawaii!

HOME | SQL Tutorials | XML Tutorials | OKIWEB | EMAIL ME | ASP Alliance