Please Help Me

  • I have One table like this..

    IdPatientIDVisitidcreationTimeServiceAdjustTime

    ---------------------------------------------------------------------------------------

    110112013-02-01 17:26:372013-02-07 17:26:37

    210122013-02-02 17:26:372013-02-07 17:26:37

    310212013-02-07 17:26:37null

    410312013-02-07 17:26:37null

    If I am selecting data from this one I need to get

    If ServiceAdjustTime is null then in that place we will get creation time...

    select id,patientid, visitid,ServiceDate from table

    -----------------------------------------

  • Use the COALESCE function.

    John

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

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