Problem with LIKE operator
Posted on 1998-03-09
i want to search wild characters along with the combination of other characters. how do i do that using LIKE operator. i am using Access 7.0. Ex : if the value of the field in the table is having values as, Hello and ?Hello. I want to search the string "?Hello" only. I tried thhis LIKE statement.
WHERE<Field> = "bc"
AND <Field1> LIKE (chr(63) &"*Hello*");
But this retrieves both the records with "Hello" and "?Hello".
Similarly i want to use other wild characters(overriding their default meaning). Any suggestions.?