Adding Text

[FontanaS]

I have the following code that updates the SQL column with the variable. It works great.

cmd=cmd & "Rmks='" & ucase(trim(TOData(9))) & UCASE(Session("USERID&quot) & "' "

Now I want to add the words 'MODIFIED BY -' In between those two variables. I am getting errors on the syntax.
Can anyone help me with the ' and the "?

THANKS!

 

[GaryC123]

strTemp = ucase(trim(TOData(9))) & "MODIFIED BY -" & UCASE(Session("USERID&quot)

cmd=cmd & "Rmks='" & strtemp & "'" Saturday 12.00

20.00

3.00am

Sunday [img http