select substr(pipecode,6,10) as result from tbgeneralmap where cast(projectcode as int)<=15 substr(pipecode,6,10) pipecode字段名,6左边开始第6个字符,10取10个字 cast(projectcode as int) cast将projectcode转化为int型,