Syntax error??

I am trying to setup a variable in my asp here is the code below...

set rsRAM = conn.Execute("Select * from TVIMAIN WHERE SYSCAT Like '" _
& Request.QueryString("SystemId") & ITEMTYPE = RAM "'")

and here is the error message I am getting... I am almost sure that it is just syntax...

If anybody has any clues to help me resolve my problem please post

Kind Regards,
Hakan

Try this:

Code:

---

"Select * from TVIMAIN WHERE SYSCAT Like '" _
& Request.QueryString("SystemId") &"' AND ITEMTYPE = 'RAM'"

---

Hope it helps

Perfect... Thank you...

Kind Regards,
Hakan