...the list for inadvertently solving my problem about subscripting. I asked for a suggestion about rephrasing a query with "...peopcode[1,2] = my_var". The obvious solution was "...substr(peopcode,1,2)" Thanks for the unrelated question about updates. Scott
