DECLARE @t TABLE (A varchar(25))
INSERT @t values ('77.88.99.100')
SELECT
PARSENAME(A,1) AS 'First selected'
, PARSENAME(A,2) AS '2nd selected'
, PARSENAME(A,3) AS '3rd selected'
, PARSENAME(A,4) AS '4th selected'
from @t
The question is: (select 1)
a. Are the values returned First selected 77, 2nd selected 88,3rd selected 99,4th selected 100'
b. Are the values returned first selected 100, 2nd selected 99,3rd selected 88, 4th selected 77
c. No values are returned.
INSERT @t values ('77.88.99.100')
SELECT
PARSENAME(A,1) AS 'First selected'
, PARSENAME(A,2) AS '2nd selected'
, PARSENAME(A,3) AS '3rd selected'
, PARSENAME(A,4) AS '4th selected'
from @t
The question is: (select 1)
a. Are the values returned First selected 77, 2nd selected 88,3rd selected 99,4th selected 100'
b. Are the values returned first selected 100, 2nd selected 99,3rd selected 88, 4th selected 77
c. No values are returned.