Hello everyone,

Something I have been able to accomplish some time ago but I haven't got it documented :(, in the following stored proc I manage to show my information in a hiearchial maner, and displays when running my information like:

ASP
ASPtools
ASPtools2
ASPprograms
etc.....


CREATE PROCEDURE sproc_bookmark AS
SELECT bookmark_title = convert(varchar, SPACE(2 * (bookmark_level - 1) ) + bookmark_title)
FROM adw_bookmark
ORDER BY bookmark_thread_id
GO

Since I'm parsing this SPROC through asp.net I would like to have the   instead of a space within my SPROC so it's already pre-formatted and ready to go in my ASP.NET page (in html format) when I receive the information from my database.....

But how do you do this?????

THANKS!

Evan

+ ' ' +


just place that between your two fields, and yes those are single quotes