1.SELECT * FROM LR_DictAdm where replace(名称,chr(13),'')<>名称
chr(13)空行筛选
2.SELECT * FROM LR_DictAdm where replace(名称,chr(9),'')<>名称
chr(9)空格筛选
1.SELECT * FROM LR_DictAdm where replace(名称,chr(13),'')<>名称
chr(13)空行筛选
2.SELECT * FROM LR_DictAdm where replace(名称,chr(9),'')<>名称
chr(9)空格筛选