Which is Faster?

[Imperceptus]

Which is faster?

Code Select Expand

sqlCommand = Mid(sqlCommand, 1, Len(sqlCommand) - 2) & ")"
or

Code Select Expand

sqlCommand = Left(sqlCommand, Len(sqlCommand) - 2) & ")"

[UserLoser.]

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

[Grok]

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.