just as the question can we do something to get the length and first 3 characters of the employee name of one column Please do not mark as answered or duplicate i have the test tomorrow Advance SQL so I am trying to solve some imp question.. Please answer the problem thanks again