where MyValue is the variable that holds the value you are searching for and is a text field. If the field is a numeric field then it would beCode:Select * from Table Where MSSV='" & myValue &"'"
Code:Select * from Table Where MSSV=" & myValue