troubleshooting Question

SQL JOIN?

Avatar of Joel_Sisko
Joel_SiskoFlag for United States of America asked on
MySQL ServerPostgreSQLMicrosoft SQL Server 2005
6 Comments3 Solutions169 ViewsLast Modified:
How do I take data from one field and join it with data from another field, plus provide some addtional text around that data. So as an example:

TableUserName                 TableUserNumber                  

Joel                                     555-1212
John                                    555-1213
Mary                                    555-1214


The result needs to look like the below while adding the following characters, "=" and "!"

Joel=555-1212!
John=555-1213!
Mary=555-1214!

Joel
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros