...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
