3 english! DO YOU SPEAK IT
source | link

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 followingfollowing queries:

Declare @name as varchar(100); 

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

But output will come first row only

select * from aa;
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

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

2 english! DO YOU SPEAK IT
source | link

(I am using Sql server 2008R2)select * from aa; ID FirstName LastName City 29 Abcrdrr hai chennai 67 adf adf adsf 1 John vinoth CITY

select * from aa;
ID  FirstName   LastName    City
29  Abcrdrr     hai         chennai
67  adf         adsd        adsf
1   John        vinoth      CITY

I want to display lastnamethe lastname column without last character i. I am using following querysqueries:

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

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

Thanks

(I am using Sql server 2008R2)select * from aa; ID FirstName LastName City 29 Abcrdrr hai chennai 67 adf adf adsf 1 John vinoth CITY

I want to display lastname column without last character i am using following querys

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

Thanks

select * from aa;
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

1
source | link

Remove last character in selected column?

(I am using Sql server 2008R2)select * from aa; ID FirstName LastName City 29 Abcrdrr hai chennai 67 adf adf adsf 1 John vinoth CITY

I want to display lastname column without last character i am using following querys

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

Thanks