7 Replies Latest reply on Feb 27, 2013 9:58 AM by philmodjunk

    Retrieve records that starts with "ar", "za" etc in a name field

    AdminWebphil

      Title

      Retrieve records that starts with "ar", "za" etc in a name field

      Post

           Hi, 

            

           I have currently a database of 380 000 companies in a given location. I need to find and extract all the companies that starts with "a" "b" "c" etc so ill have 26+ excel files that can be extracted. What operators do i use in the my business name field so that it will only return businesses that starts with A or B or C

            

           Many thanks if someone replies. :D