Advertisement

Latest Post

Saturday, 1 October 2016

How to use SUBSTRING () function in Sql Server


SUBSTRING () - Extract characters from a text field

Example: - Below is the simple example of SUBSTRIGN function

DECLARE @STRING VARCHAR(50)='EXAMPLE OF SUBSTRING FUNCTION'

SELECT
 SUBSTRING(@STRING, 1, 7)

This gives the Result: - EXAMPLE

Government Jobs