I probably wouldn't do it with a UDF since my original goal was to make it more elegant and tacking on a UDF makes things messy. :) My real question is if there's a native SQL command to do it. The rest of the post was more curiousity than anything.

Thanks,

Michelle

>even if you could do it with a UDF and use it in a SELECT - SQL statement it would not be Rushmore optimizable; this defeats the purpose of using a SELECT - SQL statement. Thus, a series of XBase command would be just as fast as (SELECT-SQL + UDF)