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.