avatar
about mixed case string# Database - 数据库
e*o
1
DB2
A string is stored as mixed case (e.g., 'Training'). Is there a way to write a
SQL select when the search string could be 'trAiNG' or any string that match
the letters but not the cases?
Thanks.
avatar
l*e
2
You may want to use UPPER() or LOWER()

a

【在 e**o 的大作中提到】
: DB2
: A string is stored as mixed case (e.g., 'Training'). Is there a way to write a
: SQL select when the search string could be 'trAiNG' or any string that match
: the letters but not the cases?
: Thanks.

avatar
e*o
3
thanks. I just thought of it right after this post.

write
match

【在 l******e 的大作中提到】
: You may want to use UPPER() or LOWER()
:
: a

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。