Hunter Hillegas <[EMAIL PROTECTED]> writes: > I cannot determine what character is stored in a varchar... > For instance: > thedonnaholics=# select state from mailing_list where rec_num = 7; > state > ------- > (1 row)
I'd say it's either NULL or between one and five space characters. To find out, try something like select '>' || state || '<' from mailing_list where rec_num = 7; regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]