How to find Substring in sql server

Substring function

As name suggests,it is use to extract some part of string or character from string/expression.

Syntax:

substring(‘expression’,starting-point,end-point)

Here substring require three parameters
1. expression – Can be string, character, binary,text or column name from table.
2. starting-point – Its integer value that represents starting point of the expression.
3. end-point – It represents that how many character you want to extract from expression.

Example:

select ‘Output’ = substring(‘Hello World’,6,len(‘hello world’))

Leave a Reply

  

  

  


1 + = 6