Need to connect a table, but have to manipulate it to connect. I’m not familiar with the position function. Is there an alternative available?
Left Outer Join
C06 On '6' <= C14_T
And C06_P = C14_P
And C06_CL = C14_D
And C06_CN = IF (Position('0', C14_D_S) = 1,
substring(C14_D_S, 2, 7),
left(substring(C14_D_S + '0', 1,
position('0', C14_D_S + '0') - 1) + substring(C14_D_S + '00',
position('0', C14_D_S + '0') + 1), 7))
Would this instance call for a case when?
New contributor
T S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
6