substring functions
Substring functions: LEFT and RIGHT in SQL Server 2012
Sometimes instead of use substring function You may use LEFT or RIGHT function.
In which situation using these functions?
If ... l string will be return.
SELECT LEFT('abracadabraS',100) as mysubstring;
SELECT RIGHT('abracadabraS',100) as mysubstring;
Substring functions: LEFT and RIGHT in SQL Server 2012
Sometimes instead of use substring function You may use LEFT or RIGHT function.
In which situation using these functions?
If ... l string will be return.
SELECT LEFT('abracadabraS',100) as mysubstring;
SELECT RIGHT('abracadabraS',100) as mysubstring;