select G_SN,G_XueXiaoSN,LEFT(G_XueXiaoName,4),RIGHT(G_XueXiaoName,3) from NongCun_GangWei 查找G_XueXiaoName字段的前4个文字,和后3个文字
select G_SN,G_XueXiaoSN, SUBSTRING(G_XueXiaoName,3,2) from NongCun_GangWei 查找G_XueXiaoName字段从第3个文字开始,查找2个文字