Suppose I have data as follows, Emp_name|Emp_Id|Emp_dept Leonardo DiCaprio|1000|Finance Cristian Bale|1004|Security Jennifer Lawrence|1002|HR Morgan Freeman|1006|Admin Now say I want to add, prefix 'Dr. ' to every entry under column name Emp_name. For example, data in output should be something as follows, Dr. Leonardo DiCaprio|1000|Finance Dr. Cristian Bale|1004|Security Dr. Jennifer Lawrence|1002|HR Dr. Morgan Freeman|1006|Admin Or maybe I want to add, suffix 'ABC' to every entry under column name Emp_Id. For example, data in output should be something as follows, Leonardo DiCaprio|1000ABC|Finance Cristian Bale|1004ABC|Security Jennifer Lawrence|1002ABC|HR Morgan Freeman|1006ABC|Admin
Hi, Xdshi.. thanks for your help... it works. What I wanted to know is that you have marked the data type section to show that this logic works on string only... right? Or you want to show that data types on both sides should be matching.