If you want to convert null fields into something else inside your select command, you can do that with "Coalesce".
select
custid, coalesce( region, ' ') as region
from Sales.Customers
order by region;
This SQL query will show null regions as space.
You can also use ISNULL() in the same way. For example, select ISNULL(region, 'none') as region from Customers
ReplyDelete