How to remove the Employee ID from Query.

[Sandeepesh shah]

Dear All,
I am executing a Qry like Select EmpName from Empolyee;

Result : RajesKumar#00214588

But I wnat to retriew the value only like RajeshKumar and want to remove the EmployeeID from result.

So How I can get the Substring in SQL Query.

[Sridhar Santhanakrishnan]

Take a look at combining CHARINDEX() with SUBSTRING()