Replace Only second character with # in the name.

[ThriVikram]

Hi,

In a DB2 Table, say Employee, I need to replace only second character with # in the first name. How to do that?

Can someone please help with this question. I was not able to understand that question and could not answer it.

[Robert Sample]

This may have been a question to determine your problem-solving techniques, or it may have been a question to check your knowledge of DB2 functions. Questions that would need to be answered include:
- Is first name a column in the table?
- If not, is the employee name in first name last name order or last name, first name order?
Depending on the answers to these questions, you should have mentioned SUBSTR and LOCATE functions.

[Anuj Dhawan]

Assuming EMP_NAME is the column for first name, this should help:

Code: Select all

SELECT EMP_NAME,SUBSTR(ENAME,1,1)||'#'||SUBSTR(EMP_NAME,3,LENGTH(EMP_NAME)) FROM EMPLOYEE;

where EMPLOYEE is the table name.