SQL Server Functions

SELECT USER_NAME();
SELECT SYSTEM_USER;
SELECT SESSION_USER;
SELECT CURRENT_USER;
SELECT PATINDEX('%schools%', 'W3Schools.com');
SELECT QUOTENAME('abcdef');
SELECT QUOTENAME('abcdef', '()');
SELECT REPLICATE('SQL', 5);
SELECT REVERSE('SQL Tutorial');
SELECT STR(65);
SELECT ASCII('Ajeet');
SELECT CHAR(65);
SELECT UPPER('Ajeet');
SELECT LOWER('Ajeet');
SELECT SUBSTRING('SQL Tutorial', 5, 5) AS ExtractString;