>Hi Jim,
>
>What is the SPACE(LEN()) about? I would expect performance to be fine just indexing on Posted and running the REPLACE command the way Randy already has it.
>
>Mike
Mike,
I don't think an index on Posted will optimize EMPTY(Posted), that's why I suggested creating an expression of Posted = < something > the something being the equivalent of empty(posted)