• Hello. Based on your post you could take it a step further and create a temporary table instead of a cursor and use a function to assign the appropriate value to the column. When finished select the rows from the temp table.

    Everett



    Everett Wilson
    ewilson10@yahoo.com