InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:17:13 GMT20http://www.sqlservercentral.com/Forums/Topic1417055-2846-1.aspxUse the COALESCE function.JohnThu, 07 Feb 2013 07:19:34 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1417055-2846-1.aspxI have One table like this..Id PatientID Visitid creationTime ServiceAdjustTime---------------------------------------------------------------------------------------1 101 1 2013-02-01 17:26:37 2013-02-07 17:26:372 101 2 2013-02-02 17:26:37 2013-02-07 17:26:373 102 1 2013-02-07 17:26:37 null4 103 1 2013-02-07 17:26:37 nullIf I am selecting data from this one I need to getIf ServiceAdjustTime is null then in that place we will get creation time...select id,patientid, visitid,ServiceDate from table-----------------------------------------Thu, 07 Feb 2013 07:11:36 GMTkalivaraprasadm