Subject: | Re: Like
| Date: | Fri, 29 Dec 2017 04:48:34 +1000
| From: | Bernie van't Hof <berniev@bje.com.au>
| Newsgroups: | pnews.paradox-dos
|
Good point.
A couple of quick tests shows pdox dos qbe doesn't do anything useful
with a LIKE on a currency column, unless exact match, so maybe just do same.
As for date "Can't use patterns with LIKE or range operators" and less
than a full date gives "Expression makes no sense" but will find exact
match full date spec. So is doing LESS than nothing.
- Bernie
On 28/12/17 10:49 am, Michael Kennedy wrote:
> So, on integer/fl-point/date fields, I expect that "like" has no effect?
|