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

David,

SELECT test_number
FROM bronx.test_test_details_all_mcm
WHERE test_description LIKE ' %'
;

"TEST1P1 " "[ 1.8V Continuity (274 pins) ]"

"TEST1P2 " "[ DDR3 Continuity (287 pins) ]"

"TEST1P3 " "[ PCIe Continuity (82 pins) ]"

"TEST2P1 " "[ CLK_REF_A_IN Differential ]"

"TEST2P2 " "[ DDR3_REF_CLOCK Differential ]"

They do have a space at the beginning. My bad.
Thank you,
Sarwar

________________________________
From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Wednesday, July 5, 2023 6:06 PM
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

On Wed, Jul 5, 2023 at 2:56 PM M Sarwar <sarwarmd02(at)outlook(dot)com<mailto: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.