I am somewhat experienced using Access Databases in ASP, and I am developing a larger scale script that will require a MS-SQL Database. I have everything set up properly and I am able to load data from my database into an ASP page, but when I do, it seems that the data has an extra space after the last character. So when I try to include a piece of data into a url it adds an extra space and comes up as a broken link.

I've checked and double checked by data, and there are no spaces at the end of any of the data I input, nor do I have an extra space in my code. I never experienced this problem using Access, does any one know why MS-SQL is doing this to me, and how I can get around it? Any help would be appreciated! Thanks!