Get Substring

hi all,

i want to get a substring from a string by start possistion and length of substring, but there is no function to do this,

please help me!

There is a built in expression to do this, called mid(). For example, mid("a string", 2, 3) returns "str". Refer to the system expression manual page for other useful expressions.