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(163.2, 72%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
I have a table which have columns Country, Region and Sales. Actually I have 70 columns in my table.Its just a sample data.
Now my requirement is I need to create a query which will select all columns from the table, but I have to replace country value as Unknown if it is null.
Could any one please help how to do
![](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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
In SSMS right click on the table, use script as SELECT. Then scroll down to the Country column and change is to
ISNULL(Country, 'Unknown') as Country
Hi @Anonymous ,
I need to create this inside a query .
Could you please help
What exactly do you mean? What you're using?
I have a table which have 70 columns and in that I have column named as Country.
Now my requirement is I need to select all the columns from table and need to show If country is null then.
Ok, this is exactly what I suggested. ISNULL function can be used or alternatively you can write
case when Country IS NULL then 'Unknown' else Country end as New Country if you want to make it a new column.
Since you want to select all 70 columns, the simplest way is to script the select statement in SSMS by right clicking on the table and selecting 'Script as Select'