关于查询“中文”的问题
我现在需要查询一个字段,查询出它是中文或者是0-9。sql语句这样写怎么不行呢?
select s.ID,s.FileName,s.Info,s.Grade,s.Chinese,s.Crack,s.Best,s.Member,s.AddDate,s.TotalHits,s.Brief,c.ID,c.ClassName from Software s inner join Class c on s.ClassID=c.ID where s.Hidden=0 and s.PostType<>1 and not((ASC(s.FileName) between 48 and 57) or (ASC(s.FileName) between 65 and 90) or (ASC(s.FileName) between 97 and 122)) order by s.ID DESC
系统提示说ASC错误,但是在access下又可以。请问如何修改。