I need two columns from a table & I need one computed column of count() Ex: Employee table Emmployeeid LastName 1 Level 2 Target 3 David This is the table. I need the result 3 columns. These 2 columns & third computed column consists of no. of e. Answer should be like below Ans:Employeeid Lastname countof'e' 1 Level 2 2 Target 1 3 David 0 How can I write T-SQL query for this. Thanks.