Syntax error??

[HakanAzaklioglu]

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

[Negative0]

Try this:

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

Hope it helps

[HakanAzaklioglu]

Perfect... Thank you...

Kind Regards,
Hakan