> You want a varchar (or is it bpchar?), not a char. char(x) will always
> return x characters, with space padding if necessary.
"bpchar" == "blank padded char", which is what char() is mapped to
internally. As Matthew has already learned, he probably really wants to
be using varchar(), or fix it up with trim().
- Tom