Question

asp sql语句 查询某字段的字符数大于10

比如有个字段叫u_text 我想查询u_text内容的字符数大于10的记录
select * from u where .............
sql该如何写??????

Answer 1

select * from u where len(u_text)>10