"Ian Meyer" <ianmmeyer@xxxxxxxxx> 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
