"Ian Meyer" <ianmmeyer@gmail.com> writes:
> So I have a column that contains usernames that have characters such
> as �(c)(R), for example: fuch�(c)r.. is there any way to find names
> with non A-Za-z0-9?
Hmm, none of the responses so far look right to me. How about
WHERE NOT (col ~ '^[A-Za-z0-9]*$')
regards, tom lane