Find a field -- ProfessionalTitle

select * from syscolumns A inner join sysobjects B
on A.id = B.id
where A.name = 'professionaltitle'

select professionaltitle,* from DMFEMPLOYEEENTITY where professionaltitle <> ''
select professionaltitle, * from dirpartytable where professionaltitle <> ''