SQL String Functions

-- SQL String Functions (Samples)
--1-) LEN: It gives charater length
Select EmployeeID, LEN(LastName) as [LastNameCharacterLen], LEN(FirstName) as [FirstNameCharacterLen] from Employees
go
--2-) Concat : It merges two or more strings
Select CONCAT(FirstName , ' ' ,LastName) as [Full Name] from Employees
Select CONCAT(FirstName , SPACE(1) , LastName) as [Full Name] from Employees -- Space(1) it's a space
go
--3-) CharIndex Find out character indexs(
-- Where is the b letter? etc...
Select CHARINDEX('ber',FirstName) [{CharIndex]from Employees
Select CHARINDEX('senta',Title) as [CharIndex] from Employees
go
--4-) Lower : It gives a lower character for all strings
Select FirstName,LastName,Title,LOWER(TitleOfCourtesy) AS [TitleOfCourtesy] from Employees
go
--5-) Upper : It gives a upper character for all strings
Select FirstName,LastName,UPPER(TitleOfCourtesy) as[TitleOfCourtesy], Title from Employees
go
--6-) LTrim ve RTrim : It's remove space if you use Ltrim = clear left spaces , Rtrim clear right spaces
Declare @character varchar(30)
set @character=' from which data from SQL Server '
Select @character as[ Karakter]
Select LTRIM(@character) as[Left Trim]
Select RTRIM(@character) as[Right Trim]
go
--7-)Substring : This method extracts strings and create a new string value
Declare @city varchar(20)
set @city='Istanbul,Turkey,Canada'
Select SUBSTRING(@city,0,5)
Select SUBSTRING(@city,0,15)