Switch field in select statement based on null values dates

See more:

SQL-Server-2008R2

Dear Expert,


Database :: ms sql server database

A table with the following fields

Table Trial

idno name first_date second_date
--------------------------------------
001 ivy 22/12/2017 17/11/2017
002 jon 14/03/2017
003 pet 15/09/2017

Request

A select statement which will select either field first_date if second_date is null else
it should select second_date


How do you accomplish this in ms sql server select statement ?


Thanks

What I have tried:

Its an on going development, looked at earlier codes no sample code