| Desc. | My SQL | PostgreSQL | SQL Server |
|---|---|---|---|
| Length of String |
LENGTH(str) / CHAR_LENGTH() |
LENGTH(str) |
LEN(str) |
|
UPPER(str) / LOWER(str) |
UPPER(str) / LOWER(str) |
UPPER(str) / LOWER(str) |
|
| Substring |
SUBSTRING(str, start, length) / SUBSTR(str, start, length) |
SUBSTRING(str, start, length) / SUBSTR(str, start, length) |
SUBSTRING(str, start, length) |
| Extract characters from the left / right side of a string |
LEFT(str, n) / RIGHT(str, n) |
LEFT(str, n) / RIGHT(str, n) |
LEFT(str, n) / RIGHT(str, n) |