On 1/31/2011 9:12 AM, George Gallen wrote: > Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not do the > job? > or FXI=CHANGE(FXI,CHAR(253),"")
<snip> That would work for the original poster's specific example which has trailing value marks. It would fail badly in any other situation. Consider a string of "a": @VM: "b": @VM: @VM Convert it and your result is "ab", which is a single value. I think perhaps the best answer to the original poster's question depends upon what the true need and possible data structures are. -- Allen Egerton _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
