This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 70%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anyone please let me know why I am getting the below error
Hi @ASHMITP ,
Could you please provide any update?
Please remember to click "Accept Answer" and upvote it if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
It would be more helpful for other experts to be more willing to help you with your issue.
Thank you for understanding!
Best regards,
Melissa
Hi @ASHMITP ,
Welcome to Microsoft Q&A!
You could use IIF instead of 'if'.
syntaxsql
IIF( boolean_expression, true_value, false_value )
Please refer below:
select IIF([visit_id]='abd',"yes","No")
from dbo.data_pcoc_episode
Best regards,
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.