>I have a table based on a warehouse inventory. Each record represents an item in the inventory and contains an Item #, ROW, COLUMN AND LEVEL. What I need to do is return a value for each unique row with the high and low values for column and level. See sample data below: (sorry about the lack of spacing. I don't know how to stop UT from removing spaces)

Wrap the stuff you want using < pre > and < /pre >. This will treat it as preformatted text (or code) and leave the spaces.

>
>
>Item Row Column Level
>
>123 1 02 A
>234 2 05 D
>345 3 01 A
>456 1 01 F
>567 2 03 A
>678 3 07 H
>789 1 04 C
>890 2 01 L
>901 3 09 F
>
>
>This should return
>
>row clow chigh llow lhigh
>1 01 04 A F
>2 01 05 A L
>3 01 09 A H
>Thanks for any help

select row,min(column) as 'clow', max(column) as 'chigh',min(level) as 'llow',max(level) as 'lhigh';
   from mytable group by nrow

HTH.