Monday, 14 November 2016

SQL SERVER LTRIM FORMULA

SQL SERVER LTRIM FORMULA

-- THEORY

-- SELECT LTRIM(' VALUE WITH SPACES') AS [ALIAS NAME OF FIELD VALUE]

-- EXAMPLE

SELECT LTRIM(' TRIM THE SPACES ON THE LEFT OF THIS VALUE') AS [LEFT TRIM FORMULA]

No comments:

Post a Comment