I can't find the way for a correct use of "%"
in connection with WHERE and LIKE.
My current code is
SELECT t.Campo1 INTO Extracted
FROM tablebase AS t, SearchedList AS s
WHERE (((t.Campo1) Like [s].[Cerca]));
My table to be searched, (t) is
Red bloom
Blue ribbon
Green Leaf
Yellow umbrella
Red table
Violet dream
Orange blossom
Green tea
Indigo virgin
Black sabbath
and the table of items to be found (s), is
Red
Green
..........
with the code I quoted I only get exact match,
so result is null. how do I place the % char here, for partial match?