You can use SPT parameters
lcPassword = ...
lcSql = "INSERT INTO mytabel (password) VALUES (?lcPassword)
lnRetVal = SQLEXEC(lnConn, lcSql)
...
>
>When I am using this library to store encrypted passwords in SQL Server, sometimes the encypted string has embedded single quotes. This screws up the INSERT command in SQL because it uses the single quotes to enclose the string. Are there work arounds to this? One was to replace the single quote with 2 single quotes, this singles to SQL Server that it is not an end of string terminator... any others?
--sb--