Sql server replace empty string with null The length of a string is only null when the string is null. I have a table that has a string value of 'null' that I wish to replace with an actual NULL value. INTO to replace empty string or NULL value; Post reply. This returns the output as 1900-01-01. SQL Server Functions. Dec 6, 2015 ยท Be careful if you want to stuff your nullable DateTime field like above with certain value such as Today's date, because t-SQL datetime field would supply a default 1900/01/01 when a datetime field is empty not null: First, test for empty, NULLIF(dateField, ''). For the first part I wrote: select last_name, commission_pct from employees; But I am unable to get how to replace NULL values with "No Commission". Everything you perform with NULL will result in NULL as well. '', ' ', ' '). Development - SQL Server 2014; SELECT . mvkozxdsviwqqcsgplpmrrsslurphunghkxyyzxaypqhfotsybihjzorfvuuhynaaqoolbklpafjppmy