lowercase to UPPERCASE

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • t8ntboy
    #1

    lowercase to UPPERCASE

    I have a table the contains field called PersonID. Each record in the
    personID field begins with the letter "p" in uppercase or lowercase. I
    want to run a query that finds all of the lowercase "p"s and converts
    them to uppercase. I cannot figure out how to do this easily as there
    are over 30,000+ records. Can someone point me in the right direction?
    Thanks

    Tags: None
    • t8ntboy
      #2
      Re: lowercase to UPPERCASE

      Nevermind...



      t8ntboy wrote:
      I have a table the contains field called PersonID. Each record in the
      personID field begins with the letter "p" in uppercase or lowercase. I
      want to run a query that finds all of the lowercase "p"s and converts
      them to uppercase. I cannot figure out how to do this easily as there
      are over 30,000+ records. Can someone point me in the right direction?
      Thanks

        Comment

        • Bgreer5050
          #3
          Re: lowercase to UPPERCASE

          I do that all the time. You figured it out in the 5 minutes from when you
          posted......did n't you?


          "t8ntboy" <t8ntboy@gmail. comwrote in message
          news:1168982554 .565813.109740@ l53g2000cwa.goo glegroups.com.. .
          Nevermind...
          >
          >
          >
          t8ntboy wrote:
          >I have a table the contains field called PersonID. Each record in the
          >personID field begins with the letter "p" in uppercase or lowercase. I
          >want to run a query that finds all of the lowercase "p"s and converts
          >them to uppercase. I cannot figure out how to do this easily as there
          >are over 30,000+ records. Can someone point me in the right direction?
          >Thanks
          >

            Comment

            Previous template Next
            Working...