Hallo,
Does anybody know how I can check for values in a field (type varchar) that consist of characters other than numbers (0, 1, 2, 3, 4, ...9) ?? For example, the query will return 12345-A, but not 12345.
Or is this only possible in a program?
Thanks in advance,
stephen.

Taking a shot at this, try:

select * from my_table where field1 NOT MATCHES ("[0-9]*[0-9]*[0-9]");

Does that work for you?