Monday, 04 April 2005
MS Access: using the LIKE function with a parameter
I wanted to do something like SELECT * from MyTable WHERE [Action] LIKE 'Hello%'
but using a parameter instead of hard-coding the 'Hello' into the query.
using VS and OleDb, the syntax for this wasn't obvious, what finally works is:
SELECT * from MyTable WHERE ([Action] LIKE ? + '%')
Monday, 04 April 2005 17:51:14 (GMT Daylight Time, UTC+01:00) Database