quering active directory with tsql select statement

[andyvldmrsky]

dear friends !

could you please help me !

i am trying to get the text stored in the "description" field of a computer properties in active directory.

i use a code like this:

select * from openquery ( ADSI, 'select name, description from ''LDAP:// OU=computers, OU=..., DC=..., DC=com'' where objectcategory = ''computer''' )

i fail because this description field is so called multi-valued as far as i understand it.

so my question is: is there a way to get this text ? there should be - the active directory console itself gets it !

thank you in advance !