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
@postgresql.org
Subject: Re: [GENERAL] list non alphanumeric
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: 12 April 2013 08:41 AM
> To: pgsql-general@postgresql.org
> 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 didn't say that was
acceptable, jus
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: 12 April 2013 08:41 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] list non alphanumeric
>
>
>
> On 4/11/2013 11:23 PM, Baboo, Is
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
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 like + or * and the list goes on.
I did google a bit and tried:
/select * from TA
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]%'
