Hi
Firstly let me mention I am a noob to postgres,DB and sql anyway, I have a
column with First names and need to list names that have non-alphanumeric
characters in them like + or * and the list goes on. I did google a bit and
tried:
select * from TABLE where first_name not like '%[a-z0-9]%'
08:41 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] list non alphanumeric
On 4/11/2013 11:23 PM, Baboo, Isa wrote:
Firstly let me mention I am a noob to postgres,DB and sql anyway, I have a
column with First names and need to list names that have non-alphanumeric
characters in them
Hi
It still displaying everything, maybe it is the spaces?
test
sadadds
Hillary
BEN NAME
BOB
/+
...skipping
ALAN MCGARVEY +
-Original Message-
From: Ian Lawrence Barwick [mailto:barw...@gmail.com]
Sent: 12 April 2013 09:08 AM
To: Baboo, Isa
Cc: John R Pierce; pgsql-general
Subject: Re: [GENERAL] list non alphanumeric
On 4/11/2013 11:50 PM, Baboo, Isa wrote:
Thanks for the response but I tried that and it does not work here is an
example of names which still display.
test
sadadds
Hillary
BEN NAME
ALAN MCGARVEY +
well, at least one of those has a space inline, you
