title: How to Duplicate Column in same table in SQL?
body: <p>i am trying to duplicate a column hotelid , and then i want to make a couples that begin with the same letter,</p>
  <pre><code>select cast (hotelid as int) as hotelid1 , cast (hotelid as int) as hotelid2
      from hotel
      where (postcode BETWEEN 1500 ANd 1999) or
      ( postcode BETWEEN 3000 and 3499) 
      and  (hotelid2 &gt; hotelid1 )
       and ( LEFT(hotelid1, 1) like  LEFT(hotelid2, 1))
  </code></pre>
  <p>how i can use the new lines  in <code>where conditions</code> ?</p>