Please Help Me

• kalivaraprasadm

  SSC Veteran

  Points: 266

  More actions

  February 7, 2013 at 7:11 am

  #270503

  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

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

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 7, 2013 at 7:19 am

  #1585416

  Use the COALESCE function.

  John