Below is a snipet of Oracle code that I am trying to change to SQL and I dont know what it means: jc1.week_no < '"' + cast(lWeek as varchar(max)) + '"))' and jc2.week ...
More like a.code + '%'. Just the right side, not both. Your original example was flawed in any event, as you'd have been looking for the literal word a.cidcode, not what was in the variable.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback