Database Lookup Functoid Return Uppercase

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Database Lookup Functoid Return Uppercase

Viewing 1 reply thread
  • Author
    Posts
    • July 24, 2006 at 10:34 PM #15108
      community-content

        when all else fails, feed the result into the *Uppercase* functoid before passing it along. this is located under the strings tab in your toolbox

        but, it would seem like the solutions that youve tried should work. Im not 100% but i will do some investigation and try to post back

      • July 24, 2006 at 10:37 PM #15109
        community-content

          I take that back, the database lookup functoid does nothing more than return a record set from your table based on a lookup value (primary key for example).
          I figured there would be some way of manipulating the output through the value extractor functoid in the second half of the operation but i was wrong.
          you must take the output from the value extractor and feed it to the uppercase functoid.

          • July 24, 2006 at 8:53 PM #15110
            community-content

              How can I return an uppcase value, last name for example, using the database lookup functoid? I’ve tried preceeding the the column name parameter with upper and toupper with no success.

              Thanks

              • July 25, 2006 at 2:25 AM #15111
                community-content

                  That was my first thought too. Problem is, I’m not getting anything returned to extract. I need to match on last_name so if the incoming data is ‘SALAZAR’ it does not equal ‘Salazar’ therfore no value from the db, Oracle BTW. What I need is to do simulate \”select (*) from customer where upper(last_name) = ‘SALAZAR’\”.

                  Thanks

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.