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:barwick@xxxxxxxxx] Sent: 12 April 2013 09:08 AM To: Baboo, Isa Cc: John R Pierce; pgsql-general@xxxxxxxxxxxxxx Subject: Re: list non alphanumeric > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John R Pierce > Sent: 12 April 2013 08:41 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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 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]%'; > > > you'll probably have to use a regex for that. > > something like... (my regex is really rusty) > > ... WHERE first_name !~ '^[a-z0-9]*$'; 2013/4/12 Baboo, Isa <IBaboo@xxxxxxxxx>: > > Hi > > 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 + Something like: ... WHERE first_name ~ '[^\w]' might do the trick. Regards Ian Barwick To read FirstRand Bank's Disclaimer for this email click on the following address or copy into your Internet browser: https://www.fnb.co.za/disclaimer.html If you are unable to access the Disclaimer, send a blank e-mail to firstrandbankdisclaimer@xxxxxxxxx and we will send you a copy of the Disclaimer. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
