Show/Hide Toolbars

TMS XData Documentation

The substring function returns a substring of the first parameter string value identified by selecting M characters starting at the Nth character (where N is the second parameter integer value and M is the third parameter integer value). N parameter is 1-based, thus N = 1 means the first character

 

Example:

 

http://server:2001/tms/xdata/Customer?$filter=substring(CompanyName, 2, 4) eq 'oogl'