String Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. String Functions
  4. 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>