Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

Substring with variable

4> DECLARE @FullName VarChar(25) 5> SET @FullName = 'George Washington' 6> SELECT SUBSTRING(@FullName, 4, 6) 7> GO ------ rge Wa (1 rows affected)