Re: Selecting rows having substring in a column [RESOLVED]

On Thu, 29 Aug 2019, Rich Shepard wrote: Aha! I thought of 'like' but forgot about ilike. That's exactly what I need. 'thought' is the wrong word. I should have written that I once knew of like and had forgotten it. Rich

Re: Selecting rows having substring in a column [RESOLVED]

On Thu, 29 Aug 2019, Adrian Klaver wrote: test=# select * from like_test where fld_1 ilike '%Winding River%'; fld_1 Adrian, Aha! I thought of 'like' but forgot about ilike. That's exactly what I need. Thanks very much, Rich