Home Forums SQL Server 2008 T-SQL (SS2K8) Update null to unknown in a table for all the columns RE: Update null to unknown in a table for all the columns

  • November 26, 2012 at 4:26 am

    #1562136

    Reddy Ksr (11/26/2012)

    Hi,

    i need query to update all the columns which ever carrying null to 'unknown' using a single query or procedure or a function.

    Can any one suggest?

    Thanks in advance.

    Just one point, how do you plan to store 'unknown' in a column which doesnt accept strings?