select G_SN,G_XueXiaoSN,LEFT(G_XueXiaoName,4),RIGHT(G_XueXiaoName,3) from NongCun_GangWei select G_SN,G_XueXiaoSN,LEFT(G_XueXiaoName,4),R
select G_SN,G_XueXiaoSN,LEFT(G_XueXiaoName,4),RIGHT(G_XueXiaoName,3) from NongCun_GangWei select G_SN,G_XueXiaoSN,LEFT(G_XueXiaoName,4),R