Monday, 14 November 2016

SQL SERVER LOWER CASE FORMULA

SQL SERVER LOWER CASE FORMULA

-- THEORY

-- SELECT LOWER('ENTER UPPER CASE VALUE OR SELECT FIELD FROM TABLE WITH UPPER CASE VALUE') AS [ALIAS NAME OF FIELD VALUE];

-- EXAMPLE

SELECT LOWER('CONVER TO LOWER CASE') AS [DISPLAY VALUE IN LOWER CASE];

No comments:

Post a Comment