What will the following query return?


CREATE TABLE #Temp
(FirstName varchar(20),
LastName varchar(20)
)

INSERT INTO #Temp
SELECT 'John', 'Smith'
union all
SELECT 'Joseph', 'Robertson'
union all
SELECT 'Robert', 'Jefferson'

SELECT substring(LastName, CHARINDEX('s', LastName)-1, 10) Name from #Temp  Read more...