How to Remove Last Character in Sql Server

Simple Example of Employee Id remoce Last Character
If u have a  like Empid like
14,8,16,19,1,18,  and you want to remove Last character i.e  ‘,’

Sql Query :
Select left(Empid,Len(EmpId)-1) as  EmployeeId  from TableName