Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Here's another good one

Author  Topic 

btrimpop
Posting Yak Master

214 Posts

Posted - 2001-10-31 : 09:10:13
Is there a way to select just the rows where a varchar column contains a string that has a capital letter in the middle of it? Say something like a name column and you want to return the rows where there is a capital letter in the string that is not the first character in the string.
For example, you want to return "petEr", but not "Peter".

   

- Advertisement -