On Thu, Mar 10, 2022 at 12:12 AM Scott Macri <sc...@bitsnbytes.io> wrote:
I've verified the data a 100 times and am totally perplexed. Thanks. > > SELECT * > FROM public.map_table > WHERE company_letters = 'abcdefg'; > > Not sure what kinds of verification you did, but did you check to make sure that there's no trailing whitespace? What do you see for that row if you run this query? SELECT company_letters,length(company_letters),company_letters='abcdefg',trim(company_letters)='abcdefg' FROM public.map_table; -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
