Search for 2nd space with charindex in a condition

[Millard]

How can I get to the 2nd or 3rd space of a condition using
charindex?

 

[JohnDTampaBay]

The third parameter of CHARINDEX is the starting position for the search. Nest a CHARINDEX within a CHARINDEX to start searching after the first (or second) space.

Position of the second space:
CHARINDEX(' ', SearchString,
CHARINDEX(' ',SearchString) + 1) --Start after 1st space

Position of the third space:
CHARINDEX(' ', SearchString,
CHARINDEX(' ', SearchString,
CHARINDEX(' ',SearchString) + 1)

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[JohnDTampaBay]

Oops! Minor correction, but it makes all the difference:

Position of the third space:
CHARINDEX(' ', SearchString,
CHARINDEX(' ', SearchString,
CHARINDEX(' ',SearchString) + 1) + 1)

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[Millard]

Thanks Angel (It works!)