Re: SQL is fetching results BLANK checks but the data has no BLANKS

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: Erik Wienhold <ewie(at)ewie(dot)name>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS
Date: 2023-07-05 22:06:17
Message-ID: CAKFQuwb5L=GtRbPm88wKU8RC9T7vLfLrv0cSLfTWeg6LA-drng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jul 5, 2023 at 2:56 PM M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:

> Yes, I am getting the same results for the following SQLs.
>
> SELECT test_number
> FROM bronx.test_test_details_all_mcm
> WHERE test_description LIKE ' %'
> ;
>
> -
>
>
How about:

SELECT test_number, '[' || test_description || ']'
FROM bronx.test_test_details_all_mcm
WHERE LEFT(TEST_DESCRIPTION, 1) = ' '
LIMIT 5;

?

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-07-05 22:36:53 Re: SQL is fetching results BLANK checks but the data has no BLANKS
Previous Message M Sarwar 2023-07-05 21:56:31 Re: SQL is fetching results BLANK checks but the data has no BLANKS