Menu
I would like to show the value "NONE" if the value in a field is null OR its value if the field is not null from a table using select statement. The statement may be similar to this:
select iif(isnull(spouse),"NONE",spouse) as spouse from biodata
568
Null Values can be replaced in SQL by using UPDATE, SET, and WHERE to search a column in a table for nulls and replace them. In the example above it replaces them with 0. Cleaning data is important for analytics because messy data can lead to incorrect analysis.
We can replace NULL values with a specific value using the SQL Server ISNULL Function. The syntax for the SQL ISNULL function is as follow. The SQL Server ISNULL function returns the replacement value if the first parameter expression evaluates to NULL.
SELECT Nz(spouse,"NONE") AS Nzspouse FROM biodata
Nz() replaces spouse with "NONE" if spouse was NULL, otherwise it returns spouse.
124
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
