I want to create the following URL:- <a href="admin/doc.asp?id=Num">Text</a> where Num is from an int field varID, and Text is from an nvarchar field. Both from a table tblxyz. The following attempt does not work:- '<a href="admin/doc.asp?id=' + STR(dbo.tblxyz.varID) + '''>' + dbo.tblxyz.varTitle + '</a>' AS DocURL Grateful for correct coding! Thanks
|How to remove numeric and alpha from an alphanumeric field?||5||69|
|SQL log file keeps growing despite getting successful log backups||4||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!