A character or string function is a function which takes one or more characters as parameters and returns a character or or number value.
SQL character functions are:
SQL character functions are:
| Functions | Syntax |
|---|---|
| lower() | |
| initcap() | |
| upper() | |
| concat() | all characters of a |
| ltrim() | The SQL TRIM() |
| rtrim() | |
| trim() | |
| substr() | all characters of a |
| instr() | The SQL TRIM() |
| length() | |
| lpad() | |
| rpad() | all characters of a |
| replace() | The SQL TRIM() |
| translate() | all characters of a |
| chr() | The SQL TRIM() |
| ascii() | The SQL TRANSLATE() |
No comments:
Post a Comment