Posted by wtfbrb on 10/13/06 19:46

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

• Next in forum: Re: Select Range
• Prev in forum: weird database back up sizes
• Thread view: Select Range

[Reply to this message]