Which is faster?
[code]sqlCommand = Mid(sqlCommand, 1, Len(sqlCommand) - 2) & ")"[/code]
or
[code]sqlCommand = Left(sqlCommand, Len(sqlCommand) - 2) & ")"[/code]

Never looked into it, but probably Left().  Mid() requires has more parameters, and has to check the start position, while Left() will always use the first character as the start position

Use Left$ instead of Left, Mid$ instead of Mid, and + instead of &, since you know for a fact you are working with strings, VB can remove all the extra crap for variants.