#ltrim

[indiandotnet]

Various available string functions in SQL Server TIP # 63

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…

View On WordPress

[carlosf0527]

Equivalent of Oracle PL/SQL TRIM function in SQL Server (T-SQL)

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…

View Post

[mononinjaentrenado-blog-blog]

Quitar espacios y poner palabras en minusculas en MYSQL

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

#córta!