Checking if first character is a *-Beast mode

ozarkram

Hi All,

I am trying to flag the rows that have the first character starting with a *...For ex: *SLD 05/11/2022 - I need to flag this 1 ..*SOLD 05/15/2022 -I need to flag this 1 ,1277489 STK#39298.32831 * -I need to flag this 0..can you please let me know how to do this..

Thanks,

Arun

MarkSnodgrass

If you are only looking at the first character in a string you can use the LEFT function, like this:

 CASE WHEN LEFT(`orderstatus`,1) = '*' THEN 1 ELSE 0 END

MarkSnodgrass

If you are only looking at the first character in a string you can use the LEFT function, like this:

 CASE WHEN LEFT(`orderstatus`,1) = '*' THEN 1 ELSE 0 END

ozarkram

Thanks @MarkSnodgrass !...Really appreciate your help!