I have SQL database called “S1”, and a table called “WORKORDER”, inside the table, I have two field on is called “ WORKORDERID” and the second field is called “SOURCEWOID” and would like to concantanate these two fields in one fields called “TEXT10”
For example, suppose I have the records in the first and second column as shown, and I would like to write concatenation results as shown in the field text10 manually using a trigger which depends on the “SOURSEWOID” field,
“ WORKORDERID” SOURCEWOID” TEXT10
10 1 10,12 11 2 11 12 1 10,12
Anyone may send me the code and the trigger, I don’t have any experience in coding.
Thank you in advance