Ok. Everyone keep cool. LIKE does work. However, what it does not LIKE to do is to parse a concatenated string.
Therefore this will fail:
SomeFieldFromDatabase LIKE '%' + GV_PO_Number + '%'
This will work:
SomeFieldFromDatabase LIKE '%' + 0881 + '%'
Of course that is useless since our PO number is dynamic not a fixed entry.....
The solution is to work the problem. Since it does not LIKE to concatenate strings in the WHERE clause with a LIKE operator, we simply concatenate the string we intend to use in another variable first.....
Follow me here....
String Variable - GV_PO_Number
String Variable - GV_TempVar
String Variable - GV_Returned_Value
Data Assignment 1: Assign the PO Number to GV_PO_Number. (I assigned 0881)
Data Assignment 2: Use an Arithmetic expression to create the value to parse to the database
GV_TempVar = '%' + GV_PO__Number + '%'
Data Assignment 3: Execute the query (UpdateValue is simply the field name I used in an external DB)
GV_Returned_Value = UpdateValue LIKE GV_TempVar
Result = AAAC-00881
Note!! Each data assigment must be a seperate step, do not assign them in one step.
Senior Director Support Americas