Mainframe-Db2 Queries

SUBSTR
------
This is used to select a string for coparison in sql

Select * from empwhere SUBSTR(empname,4,2) = 'EN'

Here 4 is the starting postion and returns 2 characters after that.