I am working on IIS 8.1 and source & target database is MS SQL server.
I have one flag in target table with data type char(1). I want to set value NULL when it is not Y or N. I am achieving using -
If ( monitoring_flag != 'Y' and monitoring_flag != 'N')
Then SetNull()
Else monitoring_flag
When I check in database I can see empty cell for this flag and not NULL.
![Question :?:](./images/smilies/icon_question.gif)
Thanks & Regards.