Question:
In Delphi 1 I am trying to emulate the “..” function for wild card search in Paradox in Local SQL. I am aware of ‘like’ but it is not specific enough and tends to give something with everything in!Many thanks Simon
Answer:
LIKE syntax is as follows:
WHERE (LIKE "PartVal%")
That’s the equivalent of the “..” in Paradox.