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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s