Post reply

Select rows with Blank spaces

  • February 12, 2014 at 7:10 pm

    #289525

    Hi All,

    I got two columns DEATHDATE and STATUS

    I have to update STATUS Column as INVALID when data in DEATHDATE column as follows

    Example of INAVLID DEATH DATE : 1221, 12xt88,12#10, 1, ABC, #@ , etc

    Do nothing when the DEATHDATE is VALID like

    Examples of Valid/accepatable DEATHDATE: 09122012, 091212 ,******,********, 000000,00000000

    How can i achieve this.

  • February 12, 2014 at 7:53 pm

    #1688589

    What have you built so far for you query to do that update?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply