Skip to main content

Posts

Showing posts with the label get middle name from full name column in SQL Table

How to get middle name from full name column in SQL Table

The question is How get middle name from full name column in SQL Table? Full name can be like this. Santosh kumar singh Raj Narayan verma Middle name is Kumar and Narayan etc. Solution. Use instr to get the position of first space and second space.use substr to get the string from first space +1 to 2nd space - 1. I hope you will get solution. Example.  Using substr function it will get the result of middle names. Substr(colname,instr(colname, ' ', 1,1),instr(colname,' ' , -1,1))