Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT RIGHT(cus.FirstName, 2)
FROM Customer cus;
GO
/** Output**/
----
lo
ro
ia
el
ia
do
en
na
...
SELECT LTRIM(' Removes trailing spaces.');
GO
/** Output **/
-------------------------
Removes trailing spaces.
SELECT RTRIM('Removes trailing spaces. ');
GO
/** Output **/
-------------------------
Removes trailing spaces.
SELECT SUBSTRING(cus.FirstName, 2, 3)
FROM Customer cus;
GO
/** Output **/
----
aol
edr
ari
igu
ict
ern
ele
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.