Feb 27, 2008 10:05 AM|hotjava|LINK
Hi, Could anyone help on how to write a query than has wildcard and parameter both in it. I need to get all the [Store Name] that Starts any text in a text box. I use type-dataset, but when i cant find the correct grammer in the Query Build window. Eg if
user entered "cam" in the textbox. the query should return
cambridge, camabley etc.
WHERE (STORE_NAME LIKE %?)
WHERE (STORE_NAME LIKE "%?")
WHERE (STORE_NAME LIKE "%"?)
None of them worked.