Return an empty string instead of the word NULL when selecting null datetime fields in SQL Server

By Ken Fitzpatrick

This SQL Server SELECT code snippet show a simple way to return an empty string instead of the word "NULL" when selecting a datetime field from a table in SQL Server.

select
   isnull(convert(varchar(30),<datetime field name>), '') as <alias>
from <table>;

Return an empty string instead of the word NULL when selecting null datetime fields in SQL Server  (1294 Views)