the_b1ackfox
asked on
Data Manipulation
Hello SQL Ninjas,
Is there a way to get data like this:
Bob Barker Blah blah blah blah
Bob Barker Blah blah blah blah
Bob Barker Blah blah blah blah
to look like this?
Bob Barker
Blah blah blah blah
Blah blah blah blah
Blah blah blah blah
Strictly in SQL?
Is there a way to get data like this:
Bob Barker Blah blah blah blah
Bob Barker Blah blah blah blah
Bob Barker Blah blah blah blah
to look like this?
Bob Barker
Blah blah blah blah
Blah blah blah blah
Blah blah blah blah
Strictly in SQL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Both of these approaches work well.
Trofimoval & jvejskrab:
I will be awarding points as follows. 200 points a piece for the queries, 100 points to Trofimoval for first blood! I do not fully understand the queries... yet, but I certainly appreciate (and totally love) it when you guys throw something at me that causes me to learn something new. I am adding this to my knowledge base and will be spending more time with both of these queries this week. My hat off to both of you!
Fox
Trofimoval & jvejskrab:
I will be awarding points as follows. 200 points a piece for the queries, 100 points to Trofimoval for first blood! I do not fully understand the queries... yet, but I certainly appreciate (and totally love) it when you guys throw something at me that causes me to learn something new. I am adding this to my knowledge base and will be spending more time with both of these queries this week. My hat off to both of you!
Fox
select 'Bob Barker'
select ' Blah blah blah blah'
select ' Blah blah blah blah'
select ' Blah blah blah blah'