Overlapping Ranges- Query Alternative

<div class="WordSection1"><p class="MsoNormal">I have the following problem:<p class="MsoNormal"> <p
class="MsoNormal">Createtemp table ranges (Groups int, ColumnA int);<p class="MsoNormal">Insert into ranges<p
class="MsoNormal">Values(2,45);<pclass="MsoNormal"> <p class="MsoNormal">Select Groups, <p class="MsoNormal">Case when
ColumnAbetween 0 and 19 then 0<p class="MsoNormal">     when ColumnA >=20 then 20<p class="MsoNormal">     when
ColumnA>=30 then 30<p class="MsoNormal">     when ColumnA>=40 then 40<p class="MsoNormal">     when
ColumnA>=50then 50 end MinRange<p class="MsoNormal">from ranges<p class="MsoNormal"> <p class="MsoNormal">Results:
<pclass="MsoNormal">Groups minrange<p class="MsoNormal">2;20<p class="MsoNormal"> <p class="MsoNormal">What I want Is :
Onecolumn can fall into multiple ranges.  For example 45 >20, 30, and 40 so I want the following results<p
class="MsoNormal">2;20<pclass="MsoNormal">2;30<p class="MsoNormal">2;40<p class="MsoNormal"> <p class="MsoNormal">I
knowI could do a union with each range but is there any way to bring back all ranges in one query?  I need to bring
backthe values in one column so having separate columns for each range is not an option.<p class="MsoNormal"> <p
class="MsoNormal">Thankyou in advance for any help<p class="MsoNormal"> <div id="content"><p class="MsoNormal"><b><span
style="font-size:11.5pt;font-family:"Arial","sans-serif";
color:black">Pam Ozer</span></b></div><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New
Roman","serif""><br/><br /></span></div>