select 
      c.* 
   from 
      Catalog c
   where
      ( c."CatalogId" < $lovalue ) AND ( c."CatalogID" > $hivalue )