Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

Blog Post

Visiting Atlantis

This week I got to visit Atlantis. Not the mythical island, but rather the ship, the Space Shuttle Atlantis at...

2013-06-26

1,351 reads

Blogs

Microsoft Build 2026 announcements

By

Once again there were a number of Microsoft Build announcements related to data and...

T-SQL Tuesday #199: Roundup

By

A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

By

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU GRESIK Telp/Wa (0817)839777)

By R4nt4u

Kontak Cs: 0817839777 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik,...

Alamat Kantor BCA KCU VETERAN ??/Wa (0817)839777

By layanan_Bca88

Kontak Cs: 0817839777 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175

Alamat BCA KCU Mojokerto ??/Wa (0817)839777

By m4rt1n4

Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...

Visit the forum

Question of the Day

Detecting Characters

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:

SELECT CustomerNameID,
       CustomerName
 FROM dbo.CustomerName
 WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName
1              John Smith
2              Sarah Johnson
3              MICHAEL WILLIAMS
4              JENNIFER BROWN
5              david jones
6              emily davis
7              Robert Miller
8              LISA WILSON
9              christopher moore
10             Amanda Taylor
How many rows are returned?

See possible answers