I'm stuck on a select statement
I have a bit field. If the bit has a value of 1 I would like to set target to equal '_blank' but if it is 0 then target equals '_self'
SELECT IF bitField = 0 THEN '_self' AS hrefTarget
ELSE '_blank' AS hrefTarget
What is the correct syntax to do something like this?