The substring is very important and mostly used function. You can get part of string from main string. This example gives you clear idea on how to use it especially in DB2.