2 Replies Latest reply on Sep 3, 2013 10:12 AM by Alex Kerin

    Can you use wildcards in a field where you join two tables?

    Stephanie  Manley

      My data comes in the format of

      UCTX1234R

      UCTX1234L

      UCNY1234R

      UCTX1234L

      UCUT1234R

      UCUT1234L

       

      To cut down on the size of the table I join it to, I have built a secondary table like this

      UC%TX1234%

       

       

      When I try to do an inner join on these two fields which are both named task_code, I don't get data where I put in wildcards, do I need to change the character to something else?