query unparalleled value buttress pulls churned values

using following query:

    name pe.prodtree_element_name_l, max(rs.resource_value) resource_value
    prodtree_element pe
    left join resource_shortstrings rs
        pe.prodtree_element_name_l_rk = rs.resource_key
    where rs.language_id = '5'
        pe.prodtree_element_name_l <> ''
    organisation prodtree_element_name_l

i'm perplexing figure out squeeze any "resource_value". problem being while works array queries, i have sole list uses ntext datatypes instead varchars (which can't exercise max function). basically, max doesn't work here. there surrogate i ms sql server 2005?

i need prodtree_element_name_l buttress grouped, nonetheless i wholly need value resource_value column, i don't caring many relating regardless (although not, hence i can't organisation well).

update:

whoops, i wrong, prodtree_element_name_l also an ntext. competence assistance small :p