#ltrim

Various available string functions in SQL Server TIP # 63

  There are various functions available in SQL Server and it is good to know all of them you never know when they will be helpful to you.

So lets start one by one.

1) LEN :-   By the name it is clear that LEN function give length of the parameter

For example :-

DECLARE @Name AS VARCHAR(100) = ‘Rajat’ SELECT LEN(@Name)

2) LTRIM & RTRIM :-

By the name it is clear that both LTRIM  & RTRIMtri…

In PL/SQL, when the TRIM function is called with just the data parameter it will strip the leading and trailing spaces.   You can accomplish the same functionality in t-sql by using two t-sql functions:  LTRIM (strips leading spaces) and RTRIM (strips…

Para quitar los espacios se puede utilizar LTRIM y para colocar las palabras en minusculas se puede utilizar LOWER.

Ejemplo =>

var =>'Para la prueba'

UPDATE tabla set columna = replace(LOWER(var),' ','') where columnaid = id