like this?

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