3 Replies Latest reply: May 15, 2014 10:05 AM by adonis _ RSS

    simple range help

    adonis _

      Hi All,

      having an issue trying to do the following:

      (+  .In.('7' + '', '8' + '', '9' + '*')  .And. (>= "00000"  .And. <="97999")  .Or.

      (  .In.('7' + '', '8' + '', '9' + '*')  .And. (>= "99750"  .And. <="99999")

       

       

      can you guys help me figure this one out?

        • simple range help
          adonis _

          I think it works now I tried something else:

           

          (>="99900000"  .And. <="99999999")  .Or.

          (>="7**00000"  .And. <="7**97999")  .Or.

          (>="7**99750"  .And. <="7**99999")  .Or.

          (>="8**00000"  .And. <="8**97999")  .Or.

          (>="8**99750"  .And. <="8**99999")  .Or.

          (>="9**00000"  .And. <="9**97999")  .Or.

          (>="9**99750"  .And. <="9**99999")  

           

           

          let me know if you think this has any issues.

            • simple range help
              Data Kruncher

              You're going to want to use ? instead of * for that type of need.

               

              Have at look at the online help for a full (though very brief) description. Look up "wildcards" then "Creating Expressions".

                • simple range help
                  adonis _

                  DATA YOU ARE THE MASTER

                  Thanks brother.

                   

                  That ?? for single 2 characters was the sealer, that is why i had 6 extra records cause of the **,

                  you are the best, thanks again bro, ever in the east coast, give me a hollar.

                  have a great weekend.