Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

General Discussion

Eric Roberts
Eric Roberts
574 Points

How do you put angle brackets around your return

In SQL When returning information from a query how do you place angle brackets around the returned information?

3 Answers

If you could mock an example of how you want the data return that would help us give you an answer.

Eric Roberts
Eric Roberts
574 Points

First name, last name <email>

I meant how you want the data to look with the angle brackets. I'm not convinced that I understand yet but maybe this might help.

If your trying to create a Json object from an SQL query then you can use basic string concatenation.

SELECT '{ firstName: ' + FirstName + ', lastName: ' + LastName + ' }' FROM Table;