Disregard - failed to convert value from string to boolean

Can someone tell me why this isn't working....???

Nevermind - I figured it out.

Best Answer

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    Glad you figured it out. For those who may come later this was because 'en-ca' was being used as a string in a logical expression. It should use an IN expression or multiple logical expressions to compare for both 'en-us' or 'en-ca':

    CASE WHEN RIGHT(TRIM(`URL`),5) IN ('en-us', 'en-ca') THEN 'Yes' ELSE 'No' END
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**