You can become smart when you write complex SQL query. You will get better pay when you write Quickly. You will be appreciated when you use built-in string functions. Today my topic is the same, that these ideas make you perfect in using String functions.
SQL String functions..
- Length Function
- TRIM functions
- Concatenate function
- Trailining Function
- CHAR function
How to use SQL string functions..
Select LENGTH (first_name) from my_employee;
The above query counts the first_name all characters that including spaces.
Explained with examples about TRIM functions.
Select first_name || last_name from my_employee;
4. Trailing Functions
Select Trim (trailing ‘y’ from first_name) from my_employee;
Trailining is a case sensitive.
Select Soundex(first_name) from my_employee;
The above example converts ‘Srinimf’ into a Alpha-numeric value.