how can I convert varchar to int? I can not seem to cast the type (::int2) and there are no conversion functions in the docs (int(varchar)). Is there a way I am overlooking? basically I am trying to sum a field that contains all numbers but is set up as varchar.