Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL is fetching results BLANK checks but the data has no BLANKS - Mailing list pgsql-admin

From David G. Johnston
Subject Re: SQL is fetching results BLANK checks but the data has no BLANKS
Date
Msg-id CAKFQuwb5L=GtRbPm88wKU8RC9T7vLfLrv0cSLfTWeg6LA-drng@mail.gmail.com
Whole thread Raw
In response to Re: SQL is fetching results BLANK checks but the data has no BLANKS  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: SQL is fetching results BLANK checks but the data has no BLANKS
List pgsql-admin
Tree view
On Wed, Jul 5, 2023 at 2:56 PM M Sarwar <sarwarmd02@outlook.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.

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS
Next
From: M Sarwar
Date:
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS