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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jul 5, 2023 at 2:56 PM M Sarwar <sarwarmd02@xxxxxxxxxxx> 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.


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux