hihihi, cool!

Sergey, you are the best!

this is what i ended up with (pretty much a copy of your suggestion in that other thread)

SELE ;
      a.*, ;
      CombineOptions(a.OPTION) AS temp ;
   FROM ;
      partoptions a ;
   WHERE ;
      oToolBox.oDates.IsActive(DATE(), a.begindate, a.enddate) .AND. ;
      (a.custclass = "100" .OR. IsBlank(a.custclass)) ;
   GROUP BY ;
      a.OPTION, ;
      a.upchoice, ;
      a.priceadj


FUNCTION CombineOptions
   LPARA ;
      CurrentOpt
   LOCAL ;
      a_TempOptionCode(1), ;
      i, ;
      ReturnValue

   SELE ;
      q_temp.optioncode ;
   FROM ;
      partoptions q_temp ;
   WHERE ;
      q_temp.OPTION = CurrentOpt ;
   INTO ;
      ARRAY a_TempOptionCode

   ReturnValue = ""
   FOR i=1 TO _TALLY
      ReturnValue = ReturnValue + " " + a_TempOptionCode(i)
   ENDFOR

   RETURN(padr(ReturnValue, 254))
ENDFUNC

now, is there any way to tell the sql command to create a memofield instead of a 254 character field?

because in 2 occaisions i am maxing out. i could maybe splitt it in 2 or 3 fields, but it would be nicer to just have a memo field.

Thanks again Sergey!