How to get desire output [message #616334] |
Mon, 16 June 2014 00:10 |
|
aaditya321
Messages: 225 Registered: January 2014 Location: Delhi
|
Senior Member |
|
|
How to get desire output in sql query.
Need desire output:-
Rajesh Singh
Suresh Pandey
Raj Kumar Pratap
Here in first row where space should be 1 in between first name & last name
second row where space should be 2 in between first name & last name
third row where space should be 1 in middle & last name.
|
|
|
|
|
|
|
|
|
Re: How to get desire output [message #616352 is a reply to message #616347] |
Mon, 16 June 2014 02:12 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Littlefoot wrote on Mon, 16 June 2014 11:57
For 3rd row, OP wants
aaditya321 wrote on Mon, 16 June 2014 10:40third row where space should be 1 in middle & last name.
A space between "Kumar" and "Pratap"
aaditya321 wrote on Mon, 16 June 2014 10:40second row where space should be 2 in between first name & last name
@OP, how to know which is the first, middle or last name? If there is any rule, then the query can handle all the rows. Else, you have to hardcode each name.
|
|
|
|
|
|