In this example, I have shared which are the different character-manipulation functions in SQL?
CONCAT: join two or more values together.
SUBSTR: used to extract the string of specific length.
LENGTH: return the length of the string in numerical value.
INSTR: find the exact numeric position of a specified character.
LPAD: padding of the left-side character value for right-justified value.
RPAD: padding of right-side character value for left-justified value.
TRIM: remove all the defined character from the beginning, end or both beginning and end.
REPLACE: replace a specific sequence of character with other sequences of character.
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.
We use cookies to ensure that we give you the best experience and use cookies in order to personalize the advertising that you see on our website. Read more about our Privacy Policy.Got it!