Dear all,

Please give me some hints to tackle the following problem: -

strSQL = "Select location from restaurant where name = '" & strName & "'"
rstResult.open strsql, adoconnection, adOpenKeyset, adLockOptimistic

** if the string variable strName contains the character ['], i.e.
Benjimin's Restaurant, then error occurs.

Thanks in advance!

Keith