Here is an example of how to do the substring function in TCC:
1 2 3 4 5 6 7 8 9 | </ pre > < quer:projection alias = "JobCode" > < quer:substring > < quer:field path = "JobCode" /> < quer:integer >0</ quer:integer > < quer:integer >20</ quer:integer > </ quer:substring > </ quer:projection > < pre > |