Category / Section
Replace Value with Blank Cell using IF in MSSQL Server
Published:
Introduction
In some cases, you may need to replace a value with a blank cell for specific records. This article provides an expression to achieve this requirement using an IF in Microsoft SQL Server data source.
Sample Expression
Use the following expression to replace the value 1 with a blank cell for the column ‘email’:
Expression: IF(([email] = ' '),1, 0)
Result
The above expression examines the column ‘email’. If the ‘email’ is blank, the expression returns 1; otherwise, it returns 0.
Additional Resources
MB
