Hi,,

Thanks a lot..

As u said i followed.. but i am facing new problem..

select case com_owner.owner_type

when 'Company' then com_header.trade_name

when 'Person' then per.first_name end

from hr_company_owner com_owner

left outer join

HR_PERSONS per

on com_owner.owner_id= per.person_id

left outer join

hr_company_header com_header

on com_owner.owner_id=com_header.company_id

this returns error as follows...

Msg 457, Level 16, State 1, Line 1

Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.