sorry should be select * from TableName where Name like '%张%'
select * from TableName where like '%张%'
Table.Locate('name', '张', [loPartialKey]);方法即可
dreamfan(改行不做程序员,回家种地。): 真是高手!!!!!!!!
select * from TableName where fieldname like '%三' or fieldname like '%张%'或者select * from TableName where charindex('张',fieldname)>0 or charindex('三',fieldname)>0
should be
select * from TableName where Name like '%张%'
or charindex('三',fieldname)>0