Select Range

[wtfbrb]

I have a select that is grouped by building/bedrooms and I have a range
for the rent

Select Building,BR,drpBuilding.buildID,
'$' + Cast(Min(Rent/BR) as varchar(10)) + '-' + Cast(MAX(Rent/BR) as
varchar(10)) as 'PerPerson'

FROM Apt JOIN drpBuilding ON
Apt.buildID = drpBuilding.buildID
Group By Building,drpBuilding.buildID,BR

Now I want to only show a range if the rent varies, ie. I don't want to
show the range as being 510-510 I would then like just a single value
displayed. How can I do such a select?

Thanks in advance,
Mark Meadows

[Alex Kuznetsov]

CASE WHEN Min(Rent/BR) = MAX(Rent/BR) THEN ...
ELSE
Cast(Min(Rent/BR) as varchar(10)) + '-' + Cast(MAX(Rent/BR) as
varchar(10))
END