clsRecord.RunQuery() Error: (-2147217900) Incorrect syntax near 'S'.
SQL: SELECT * FROM ProductCategory WHERE [Name] = 'Pumps & VFD'S' AND ISNULL(ProductCategory.PublicWeb,0) = 1

ERROR: (0)
ADO ERROR: -2147217900
Native Error: 102
SQLState: 42000
Source: Microsoft OLE DB Provider for SQL Server
Description: Incorrect syntax near 'S'.


ERROR: (0)
ADO ERROR: -2147217900
Native Error: 105
SQLState: 42000
Source: Microsoft OLE DB Provider for SQL Server
Description: Unclosed quotation mark after the character string ' AND ISNULL(ProductCategory.PublicWeb,0) = 1'.