You can use Chr(34) instead of ". For example:
SQLStr = "SELECT * FROM SomeTableName WHERE SomeFieldName = 'ab" & chr(34) & "c'"
will store in SQLStr:
SELECT * FROM SomeTableName WHERE SomeFieldName = 'ab"c'
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...
