Teradata String Manipulation - Remove last character
Create a query that eliminates the middle Initial
Name Smith, John A Jane, Mary S
I would like an output such as this:
Name Smith, John Jane, Mary
SELECT SUBSTR('SMITH, JOHN A', 1, CHAR_LENGTH(NAME)-1);
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds