Home Forums SQL Server 2005 T-SQL (SS2K5) replace characters on condition in table and cell RE: replace characters on condition in table and cell

  • April 15, 2008 at 7:04 am

    #802531

    you could try something like

    UPDATE Employees

    SET Day1= '0'

    WHERE (isnumeric(Day1) =1)

    UPDATE Employees

    SET Day1= '#'

    WHERE (isnumeric(Day1) <>1)

    [/CODE]

    but from the brief look at your table it looks like you have some flaws in your Db design, you could maybe improve it with better tables design and some normalisation.