SQL语句问题(10分)

PeterC · 2002-07-13

各位兄弟，请问在Paradox中实现下面简单功能的SQL语句怎么写：
查找出所有记录值长度等于4的记录
Select * From TableName Where 函数(FieldName)=4
这个函数呢？谢谢！

xeb · 2002-07-13

length()

sandal · 2002-09-07

Don't support length(), How can I do?
Listen

Foonarri · 2002-09-07

只有字符串型的才可用len('ddd')
返回 3

huawdg · 2002-09-08

SELECT * FROM TableName WHERE fieldname LIKE "____"
fieldname 应当为字符类型，"_"是通配符

pengjinlongex · 2002-09-08

Select * From TableName Where len(FieldName)=4