如何在 SQL Server 中查找所有大写的值? [英] How to find values in all caps in SQL Server?

问题描述

如何找到全部大写的列值?像 LastName = 'SMITH' 而不是 'Smith'

How can I find column values that are in all caps? Like LastName = 'SMITH' instead of 'Smith'

这就是我正在尝试的...

Here is what I was trying...

SELECT *
  FROM MyTable
 WHERE FirstName = UPPER(FirstName)

推荐答案

您可以强制区分大小写；

You can force case sensitive collation;

select * from T
  where fld = upper(fld) collate SQL_Latin1_General_CP1_CS_AS

这篇关于如何在 SQL Server 中查找所有大写的值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！