On my database I have a height column and the values are in feet and inches eg 5'10". When a new value is send to the database it is accepted an written to the database. When I want to retrieve this value from the databse i do encounter problems

strWhereClause = strWhereClause & " height LIKE '" & Request.Form("height") & "%'"

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'height LIKE '5' 5"%''.

How Can I rectify it ?

Your help is appreciatexd

When inserting quoted information, you should use 2 single quotes and 2 double quotes.

like 5'' 3"".
That's the escape chars.

dim h

h = CheckString(Trim(Request.Form("height")))
-----------
Function CheckString(string)
if string = "" then string = " "
CheckString = Replace(string, "'", "''")
CheckString = Replace(string, """, """")
End Function
-----------

Now use the sql statement.