Mr rahul kumar shukla Mr rahul kumar shukla
Mr Chinku Mr chinku
Mr rinku prasad Mr rinku prasad
Mr pintu gupta Mr pintu gupta
Mr chintu agrawal Mr chintu agrawal
dipti kumari soni dipti kumari soni
Mr kishor kumar tiwari Mr kishor kumar tiwari
Mrs asika kumar sinha mrs asika kumar sinha
mragendra mragendra
mah kum sura mah kum sura
this is the table i have only one column FULLNAME. All the values containing fullname separated by space like this::
title name middlename fullname.
I want to
the split this fullname and get title, name ,middlename, surname
if any thing missing in the fullname please dont update that value in a column like this
in second row "Mr Chinku" containing only title and name thats why title and name are filled other two column middlename,surname was blanked
please give me the solution like CURSOR ,QUERY any thing
Answer Hi Sandeep,
I did not understand your question properly. If anything is missing in fullname, do you want the query to show those values in appropriate columns and do you don't want it at all ?
eg. Mr Chinku
Should this return Title as Mr and Name as Chinku ?
eg. dipti kumari soni
Should this return Title as dipti, Name and kumari and Middlename as soni?
or Title as null, Name as dipti, Middlename as kumari and Surname as soni ? (this is not possible unless there are spaces in those particular places)
Please let me know so that I can help you further.
