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)
If I then execute:
thedonnaholics=# select count(*) from mailing_list where state = '';
count
-------
0
(1 row)
So, what is in that first row?
This also returns 0:
thedonnaholics=# select count(*) from mailing_list where state = ' ';
count
-------
0
(1 row)
Any ideas? I'd like to select all rows that contain whatever that first one
contains...
Hunter