Excellent!!!

Its time for new Doors!!!!

Excellent!!!

Its time for new Doors!!!!

Excellent!!!

Its time for new Doors!!!!

If I am not mistaken, the command just replaces/removes the spaces, and the user wants to separate the word from a sentence and add single word to the table.

May be this will help

________________________________________________________

declare @word varchar(125) = 'The Quick Brown Fox Jumps over a lazy Dog'

declare @swrd varchar(100)

declare @l int

while len(@word) > 0

Begin

set @l = CHARINDEX(' ',@word)

if @l...