sql查询方法

我想作这样的一个查询：

select * from table where name.length>10

我想作这样的一个查询，可是这样的查询是不可以，应该怎样实现这样的功能呢？

---

select * from table where len(name) > 10

---

SQL code:
select * from [table] where len(name)>10

---

select * from table where len(name) > 10

--如果要去掉前后空格.
select * from table where len(rtrim(ltrim(name))) > 10

---

select * from [table] where len(name)>10

---

SQL code:
--?
select * from [table] where len(name)>10
select * from [table] where datalength(name)>10

---

SQL code:
select * from table_name where len(col_name) > 10

---

引用

select * from table where len(name) > 10

--如果要去掉前后空格.
select * from table where len(rtrim(ltrim(name))) > 10

table是关键字,最好加上[]

select * from [table] where len(name) > 10

--如果要去掉前后空格.
select * from [table] where len(rtrim(ltrim(name))) > 10

---

引用

我想作这样的一个查询：