>Try wrapping LEFT() in PADR() so you don't have issues based on the first record in the list.
>
>Tamar
Tamar,
Thanks :) Obviously I read your response after Boris'.
This definitely did the trick!
I was wondering if you could please elaborate a little more as to why this resolved the issue. I'm not following why padding the result of LEFT() would produce more than the first two characters.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer