Yes, yes I did - but apparently didn't read it as closely as I should have because I completely overlooked that last line.
>Dorris,
>
>Did you see my explanation as to why I cast to varchar? You can not cast to nchar as it is a fixed length field, so it is always padded with spaces at the end if the length is smaller.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place