How to find names without having no space from Database?

Category: sql server datamining


KVAKVA on Fri, 22 Sep 2017 15:15:49


The below cases should have space between two names. We have some cases having no spaces in name field. 

Id Name Name Should be
1 MatteoManto Matteo Manto
2 JudithBlackwell Judith Blackwell
3 KatsuyukiTakahashi Katsuyuki Takahashi
4 FabianNiederkofler Fabian Niederkofler
5 DavidBradley David Bradley

I tried to find out second Upper case Alphabet in name field but left with desired results.

I want to extract how many such names without having no space from the database.


Tom Phillips on Fri, 22 Sep 2017 15:24:37

Please post your query questions in the "Transact-SQL" Forum.  You will get a quicker response.