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.