Re: problems with leading zero's - Mailing list pgsql-novice

On Wed, Nov 19, 2003 at 11:07:22 -0800,
  Bryan Irvine <bryan.irvine@kingcountyjournal.com> wrote:
> I'm having problems with my SQL selecting numbers with preceding zero's
> from a character field.

You want to quote the digits so they get treated as a string instead of
a number which then gets converted to a string.