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
- LPAD
- RPAD
- Soundex
How to use SQL string functions..
1.Length
Select LENGTH (first_name) from my_employee;
The above query counts the first_name all characters that including spaces.
2. TRIM
Explained with examples about TRIM functions.
3. Concatenate
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.
5. Soundex
Select Soundex(first_name) from my_employee;
The above example converts ‘Srinimf’ into a Alpha-numeric value.
Audio Post
Related Posts