select * from TABLE1 where right(RTRIM(convert(char(10),id1)),1) in ('0','2','4',' 6','8')
select * from TABLE1 where right(RTRIM(convert(char(10),id1)),1) in ('1','3','5','7','9')
select * from table1 where right(convert(char(10),id1),1) in ('0','2','4','6','8') 为 偶数
select * from table1 where right(convert(char(10),id1),1) in ('1','3','5','7','9') 为 偶数