Alter Table - Setting a Column Default Value

Replace Null or Empty Value with String Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems
Formatting a Short Date in SQL using Convert Function To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to ...