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.