Re: SQL find a string in multiple fields

[John Yeung <gallium.arsenide@xxxxxxxxx>]

On Wed, Oct 12, 2016 at 1:10 PM, Alan Shore <ashore@xxxxxxxx> wrote:
> Hi Gerald
> You have to be careful
> The % in like('%.......%')   are wildcards - BUT it does mean that the HAS to be SOMETHING before INVOICE
> So in your example
> 'Invoice Inquiry         ', - this would NOT be a hit unless you used like(Invoice%)

The % wildcard will match zero or more characters, so it will work
fine even if what you are searching for is right at the beginning.

John Y.