Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    43

    Unanswered: Only numerical values...

    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.

  2. #2
    Join Date
    Feb 2005
    Posts
    43
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •