Phillip,

>> lcSql = "UPDATE nametbl SET name = [" +lcName+ "] WHERE id = 5"
>
>I am not sure about the brackets in SQL Server, but definitely...
>
>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