Here is an example of how to do the substring function in TCC:
</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>