Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

Get index of the delimiting space

4> DECLARE @FullName VarChar(25), @SpaceIndex TinyInt 5> SET @FullName = 'George' 6> 7> -- Get index of the delimiting space: 8> SET @SpaceIndex = CHARINDEX(' ', @FullName) 9>