String Functions like LEN - Substring in SQLServer
https://sqlserver2014tutorial.com/
In this video tutorial on SQL Server 2008, we cover sql string functions that are commonly used. Here are the SQL functions:
LEN -- This sql function returns the length of an expression
RIGHT -- This sqlserver function returns the number of characters starting from the right
LEFT - This sqlserver function returns the number of characters starting from the left
LOWER -- MS SQL function converts the string to lower case
UPPER - MS SQL function converts the string to upper case
REPLACE -- Important function helps to replace characters in a field with another
SUBSTRING function -- Use this to return portion of a string expression
CHARINDEX -- You can find starting position of character in a string
LTRIM -- This function in SQL 2008 removes empty spaces from the left
RTRIM - function in SQL 2008 removes empty spaces from the right
Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/