Search found 2 matches
- Mon Dec 28, 2015 3:07 pm
- Forum: Interview Questions.
- Topic: Get the first 5 characters of a column in DB2?
- Replies: 3
- Views: 502
Re: Get the first 5 characters of a column in DB2?
Thanks Chandan. Examples in this link http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_bif_substr.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 '...
- Mon Dec 21, 2015 1:56 pm
- Forum: Interview Questions.
- Topic: Get the first 5 characters of a column in DB2?
- Replies: 3
- Views: 502
Get the first 5 characters of a column in DB2?
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?
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?