When I run an SQL statement to retrieve the extended properties of a column it always returns <Binanry> in the value column instead of what it actually is. Any ideas
Look up fn_listextendedproperty within BOL (Books Online). We don't use them (knowingly) so I can't give you much more help than just pointing you to BOL.