？？？简单问题，截取第一个字符查询？？？

select substring(name,1,1)+'区'as quwei,name from tabab11

select  left(name,1)+'区'as quwei,name from tabab11

if object_id('table1','U') is not null
   drop table table1
go
create table table1
(
 name varchar(10)
)
go
insert into table1
select 'C028' union all
select 'D026'
go
select quwei=left(name,1)+'区',name from table1   --用left函数从左侧取一个字符，然后和'区'连接
go
/*
quwei name
----- ----------
C区    C028
D区    D026

(2 行受影响)
*/

use Tempdb
go
--> --> 
 
if not object_id(N'Tempdb..#T') is null
    drop table #T
Go
Create table #T([name] nvarchar(4))
Insert #T
select N'C028' union all
select N'D026'
Go
Select SUBSTRING([name],1,1)+N'区' AS quwei, [name]
from #T
/*
quwei    name
C区    C028
D区    D026
*/