Access中关于大小写敏感查询的问题及解决方案_access like 区分大小写-CSDN博客
Delete From TableName Where ColumnName='test'
这条SQL语句会把TableName表所有ColumnName列为“test”的记录都删掉。
换成下面的解决:
Delete From TableName Where Instr(1,ColumnName,'test',0)>0
Access中关于大小写敏感查询的问题及解决方案_access like 区分大小写-CSDN博客
Delete From TableName Where ColumnName='test'
这条SQL语句会把TableName表所有ColumnName列为“test”的记录都删掉。
换成下面的解决:
Delete From TableName Where Instr(1,ColumnName,'test',0)>0