I would avoid the issue by buildng the INSERT command in a different way

Let's just insert the password string just to keep things simple.

lnResult = SQLEXEC(lnHandle, "INSERT INTO accounts " + ;
"(pswd) VALUES ('ExactPassword')"

Now if you do not want to hard code the password you'd build the INSERT command string like this

lcMyInsertCommand = "INSERT INTO accounts (pswd) VALUES '" + m.lcMyPassword + "')")

where lcMyPassword is a string variable containing the password.

good luck!

Dave.