Hello,
I'm having a small difficulty that I am hopeful there is a simple solution
for. Basically, I am doing a join on a column that is numeric in one
database but a string in the other. Something like:
...WHERE a.numeric_zipcode=b.string_zipcode::integer...
The problem is that occasionally the string zip field has some
non-numeric characters. Unfortunatley, I cannot control the sanity of the
string zip field. The question is if there is any way that in the same
query I can filter out the rows that have non-number characters in the zip
field?
Thanks for any thoughts,
Tad