SELECT * FROM CIQ_Container WHERE (CONTA_ID = '10001')
or (CONTA_ID = LEFT('10001',
(case when PATINDEX('%|%', '10001')>0 then PATINDEX('%|%', '10001')-1 else 0 end)
))
or (CONTA_ID = RIGHT('10001',(LEN('10001')-PATINDEX('%|%', '10001'))))
or (CONTA_ID = LEFT('10001',
(case when PATINDEX('%|%', '10001')>0 then PATINDEX('%|%', '10001')-1 else 0 end)
))
or (CONTA_ID = RIGHT('10001',(LEN('10001')-PATINDEX('%|%', '10001'))))
PATINDEX('%|%', '10001')-1
--------------------------
(CONTA_ID = LEFT('10001',
(case when PATINDEX('%|%', '10001')>0 then PATINDEX('%|%', '10001')-1 else 0 end)
))