That helped, I had to throw another cast in there to truncate the entire value, but isnull did the trick.

Thanks,

Phillip

Jack,

You are quickly becoming my hero. 😀

However, when I try it that way, all the comment are blank. I can do just the TranCmnt = CustPmtNo...

Ok, that at least got me past my errors, now working out the logic.

Thanks.

Phillip