7 Replies Latest reply on Apr 19, 2007 4:45 AM by Newsgroup_User

    Checking to see if a word starts with a number..SQL

    Level 7
      I have a list of companies for my work. Some start with numbers. I created a
      sorting that looks for the first letter. Works great for A-Z, but I don't
      know how to do it for 0-9. Can't compare a varchar against an int. I tried
      this, but didn't work. Any ideas?

      WHERE UPPER(Left(ORG_NAME_1,1)) IN ('0','1','2','3','4','5','6','7','8',9')