COALESCE() function will return first non null value passed in it.

e.g.

Select COALESCE(NULL,NULL,’HERRY’,’THOMAS’)

OUTPUT : HERRY