String Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. String Functions
  4. SUBSTRING is used to retrieve part of a string from another string The syntax for the function is as follows
SUBSTRING(string_to_remove_string_from, start_position, length)
6> SELECT SUBSTRING("rntsoft rntsoft",2,3)
7> GO
------
ava
(1 rows affected)