添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

Select only words with capitals

Catfive Lander Jan 9 2011 — edited Jan 10 2011
If I have data stored in my Database much like this Sentence, with Some words containing uppercase letters and some not, what is the simplest Way to select only those words which contain upperCase letters?
From the above sentence, for example, I would want to see the result :
If I Database Sentence Some Way upperCase
Note that the uppercase letter(s) will not always be at the start of a word.
Is there a simple way to achieve this? I started dabbling with REGEXP_LIKE, but my regular expressions are pretty hopeless at the best of times :-(
Jump to Answer