declare @date smalldatetime
if @m_empBirthYear='' or @m_empBirthMonth='' or @m_empBirthDate=''
set @date=null
else
set @date=@m_empBirthYear+'-'+@m_empBirthMonth+'-'+@m_empBirthDate
insert into ...... @date,.....
if @m_empBirthYear='' or @m_empBirthMonth='' or @m_empBirthDate=''
set @date=null
else
set @date=@m_empBirthYear+'-'+@m_empBirthMonth+'-'+@m_empBirthDate
insert into ...... @date,.....
end