Mike, assuming you are searching the db with parameter pSearchTerm, try something like this:
put "%" & pSearchTerm & "%" into tSearchTerm put "SELECT * FROM foo WHERE bar LIKE :1" into tQuery get revDataFromQuery(tab, return, sDBID, tQuery, "tSearchTerm") ----- "The difference between genius and stupidity is; genius has its limits." - Albert Einstein -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/parameterized-query-with-wildcard-tp4694407p4694419.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
