>>lcSql = "UPDATE nametbl SET name = '" +lcName+ "' WHERE id = 5"
>
>But will SQL Server choke on the single quote in the character string? With Bob "Skip" O'Hara the lcSql would become:UPDATE nametbl SET name = 'Bob "Skip" O'Hara' WHERE id = 5

For SQLServer:

lcSQL = "UPDATE nametbl SET name = '" + STRTRAN(lcName, "'", "''") + "' WHERE id = 5"

This will evaluate to:

lcSQL = "UPDATE nametbl SET name = 'Bob "Skip" O''Hara' WHERE id = 5"

SQL Server will understand that "''" means just a single quote - just like [Turbo] Pascal does! :)