Hey Trace,
Can you post the query that *didn't* work? You've got us restless now. :)
>Actually, I added padr() as well and that worked :o) I did remove the == at one time though in my testing so that may have actually created my problem (when I removed it)...
>
>
Steve Gibson