Query:

```
select * from aa;

```

Output:

```
ID  FirstName   LastName    City
-----------------------------------
29  Abcrdrr     hai         chennai
67  adf         adsd        adsf
1   John        vinoth      CITY

```

I want to display the `lastname` column without last character. I am using following queries:

```
Declare @name as varchar(100);

select @name = city from aa
Select @name, left(@name, len(@name)-1) as AfterRemoveLastCharacter

```

But output will come first row only