Access 2010 中的 WHERE 区分大小写
我必须将数据从 Paradox 数据库导入到新创建的 WPF / SQL-Server 应用程序中。我已成功将必要的悖论数据导入到 Access 中，现在正在编写一个实用程序来转换数据并将其导入到 SQL Server 中。
现在我遇到的问题是悖论主键似乎区分大小写。这导致了一个问题：我有一个主键为“Au”的记录，而其他记录的主键为“AU”，但它们并不相同。
现在我搜索在 Access 中编写更新脚本的可能性，以便我可以编写
UPDATE [TABLE_NAME] SET [PKFIELD]="Au1" WHERE [PKFIELD]='Au'
仅影响具有 [PKFIELD]='Au' 的行，而不影响具有 [PKFIELD]=' 的行AU'
是否有一个功能可以用于此目的或者如何实现此目的。
I have to import data from a paradox database into a newly created WPF / SQL-Server application. I have sucessfully imported the necessary paradox-data into Access and now are writing a utility that converts the the data and imports it into SQL Server.
Now I have the problem that the paradox primary-keys seem to be case sensitive. This leads to the proplem that I have records with a Primary Key "Au" and other recors with the primary Key "AU" and they are not the same.
Now I search for a possibility to write Update scripts in Access so that I can write
UPDATE [TABLE_NAME] SET [PKFIELD]="Au1" WHERE [PKFIELD]='Au'
that only affects the rows with [PKFIELD]='Au' and not the rows with [PKFIELD]='AU'
Is there a function I can use for this or how can I achieve this.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
好吧，我问得有点快。我自己找到了答案：
Ok, I was a little bit fast in asking SO. I have found the answer myself: