Monday, 14 November 2016

SQL SERVER LEN LENGTH FORMULA

SQL SERVER LEN LENGTH FORMULA

-- THEORY

-- SELECT LEN('STRING OR NUMBER FIELD VALUE') AS [ALIAS NAME FOR FIELD VALUE];

-- EXAMPLE

SELECT LEN('TEST001') AS [LENGTH IN NUMBER OF CHARACTERS OF TEXT STRING];

No comments:

Post a Comment