>oops. that is a typo. I changed it last night on the actual system (production) and I didn't change it on my develp system...thanks...
>
>any other ideas? I'm stumpd on thisone. i thought it was becuase i was not actually doing a replace....how am i populating all those fields that have null in them?

The BLANK command ?