Select first name from column in firebird.

How To select firstname from employee name in firebird.


SELECT IIF(POSITION(' ' IN column_name) > 0, SUBSTRING(column_nameFROM 1 FOR POSITION(' ' IN column_name) ), column_name) First_name from Table_name