Hello,
My query is below, as you can see I am trying to concatenate some substrings and unfortunately experiencing an error, I've tried concat and concatenate:
Routine (concat) can not be resolved.
Routine (concatenate) can not be resolved.
run sql select n.dnorpattern, h.maxcallersinqueue, h.maxwaittimedestination, h.noagentdestination, h.queuefulldestination, h.maxwaittimeinqueue from numplan as n inner join huntpilotqueue as h on h.fknumplan_pilot=n.pkid where 1=1 and tkpatternusage = '7' and ((dnorpattern like '%110' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '0')) or (dnorpattern like '%120' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '1')) or (dnorpattern like '%130' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '2')) or (dnorpattern like '%170' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '3')) or (dnorpattern like '%171' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '4')) or (dnorpattern like '%180' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '5')) or (h.maxwaittimedestination <> h.noagentdestination ) or (h.maxwaittimedestination <> h.queuefulldestination))
