sql - 当数据为小写时,T-SQL 查询失败,因为数据库以大写形式保存它
问题描述
在我的数据库中,所有数据都大写,例如姓氏 ( BRIERTON
)。当我以 ( brierton
) 之类的小写字母运行查询时,它不会找到它。是否可以在查询中放置一些东西来搜索大写或小写,以便它认为它不存在[pye_nlast] AS "Name Last"
?
SELECT
[pye_nlast] AS "Name Last",
[pye_nfirst] AS "Name First",
[EmployeeTC_No] AS "Employee TC #",
[EmploymentType] AS "Employment Type",
[RetentionCode] AS "GS #"
FROM
[OnBaseWorking].[dbo].[Employees]
WHERE
EmployeeTC_No != 'Not Assigned'
AND pye_nlast = '@primary'
对此的任何帮助将不胜感激!
解决方案
你可以强制小写:
lower(pye_nlast) = lower(@primary)
我不确定你为什么@primary
用单引号括起来。这是可疑的。
或者,如果数据真的都是大写的:
pye_nlast = upper(@primary)
推荐阅读
- python - Tkinter 图像不存在
- reactjs - 从函数调用 React 组件
- java - Http Post 多部分文件消耗 apache camel
- python-3.x - 根据分隔符拆分一列,然后在保留其他列的情况下取消透视结果
- julia - Julia 中带有子图的 hline/vline
- python - Folium Search is loading but dont show anything
- flutter - how to map database keys to Strings & display the text assigned to each key on UI screen?
- python - Python: changing decimals into integer from a text file and adding value in empty column
- selenium - how to take screen shot using selenium WebDriver on Heroku
- reactjs - Electron: How to store data in cache manually