Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT UPPER(cus.FirstName)
FROM Customer cus;
GO
/** Output **/
----------------------------------------
PAOLO
PEDRO
MARIA
MIGUEL
VICTORIA
BERNARDO
HELEN
...
SELECT LOWER(cus.FirstName)
FROM Customer cus;
GO
/** Output **/
----------------------------------------
paolo
pedro
maria
miguel
victoria
bernardo
helen
...
SELECT LEFT(cus.FirstName, 2)
FROM Customer cus;
GO
/** Output **/
----
Pa
Pe
Ma
Mi
Vi
Be
He
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.