query for data type number

[oracle]

Can someone correct this query for me:



sql = "SELECT * FROM Risk_Acceptance where Acceptance_No = "& search_view & " "


search_view is the input field which would return results of the search action.

Getting the following error:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'Acceptance_No ='.

[matthewspatrick]

Can you post the complete code that this came from?