Get the first 5 characters of a column in DB2?

[Suresh R]

Hi,

How can we get the first 5 characters of a column in DB2? Interviewer explained it again saying, how would you get the first 5 characters of say, FIRSTNAME column of DB2 table STUDENT?

Please help how to do this?

[Chandan Yadav]

Hi,

Check for SUBSTR function of Db2

Regards,
Chandan

[Suresh R]

Thanks Chandan. Examples in this link http://www-01.ibm.com/support/knowledge ... ubstr.dita has helped me. Giving it here for reference:

Example 1: FIRSTNME is a VARCHAR(12) column in sample table DSN8A10.EMP. When FIRSTNME has the value 'MAUDE':

SUBSTR(FIRSTNME,2,3) -- 'AUD'
SUBSTR(FIRSTNME,2) -- 'AUDE'
SUBSTR(FIRSTNME,2,6) -- 'AUDE' followed by two blanks
SUBSTR(FIRSTNME,6) -- a zero-length string
SUBSTR(FIRSTNME,6,4) -- four blanks

[zprogrammer]

Thanks for sharing the link , It would help people future