Select Non Alpha Contents of a Column

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Select Non Alpha Contents of a Column
Date: 2003-12-29 23:11:07
Message-ID: BC15F48B.EE7FC%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to select all rows where a certain column starts with
non-alpha characters?

I would like to select all the rows that don't start with letters.

Possible?

Hunter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Finner 2003-12-29 23:17:45 Re: Is my MySQL Gaining ?
Previous Message Tom Lane 2003-12-29 22:50:52 Lock contention (was Re: [PATCHES] update i386 spinlock for hyperthreading)