fCtciDat = 1 sqlCmd = "Select Alias from Locs As l outer join Sess As s on l.Ndx = s.Ndx Where s.sSes >= '" & fCtciDat & "' AND s.eSes <= '" & fCtciDat & "'"
After executing the above code, sqlCmd has the value "The XML was improperly formatted. Please escape it if necessary"
Do I overlook something? I don't see it.
If there is something wrong in formatting a string I would expect a runtime error message, not a completely different value in my string!