I have built a query from a table. Inside the query I need to create a new field, that takes an existing field from the table and "spares" out a portion of the data. All the data within the field (table) follows the same format (aaa_bbb_ccc). I need to extract out the middle piece. I tired setting up an expression using the split function Expr1:IIf([thread_name]="","NULL";split([thread_name],"_",2)) This does not work. Any help would be appreciated. I need to get this done for a presentation due next week (6-12-06). Thanks again.