SQL/String at main · santanudeb/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
xxx==============================================================================================================xxx

SELECT LENGTH('Test') [For MySQL]
SELECT LEN('Test') [For SQL]
SELECT UPPER('Test')
SELECT LOWER('Test')

xxx==============================================================================================================xxx

SELECT FirstName, LEN(FirstName)
FROM EmployeeDemographics
;

xxx==============================================================================================================xxx

SELECT FirstName, LEN(FirstName)
FROM EmployeeDemographics
ORDER BY 2
;

xxx==============================================================================================================xxx

SELECT FirstName, UPPER(FirstName) AS Upper
FROM EmployeeDemographics
;

xxx==============================================================================================================xxx

SELECT TRIM('    Test   ')
SELECT LTRIM('    Test   ')
SELECT RTRIM('    Test   ')

xxx==============================================================================================================xxx

SELECT FirstName,
LEFT (FirstName, 4),
RIGHT (FirstName, 4),
SUBSTRING (FirstName, 3, 2) AS From3rd
FROM EmployeeDemographics
;

xxx==============================================================================================================xxx

SELECT FirstName, REPLACE(FirstName, 'a', 'x')
FROM EmployeeDemographics
;

xxx==============================================================================================================xxx

SELECT LOCATE ('a', 'Santanu'); [For MySQL]
SELECT CHARINDEX ('a', 'Santanu'); [For SQL]

SELECT FirstName, CHARINDEX ('a', FirstName)
FROM EmployeeDemographics
;

xxx==============================================================================================================xxx

SELECT CONCAT (FirstName, ' ', LastName)
FROM EmployeeDemographics
;

xxx==============================================================================================================xxx