I am having difficulty creating an expression as part of an SQL Select query in MS SQL 2000. The expression should generate a URL. I have already done for variables that do not include a number, but now have difficulty.
The question is in the code snippet as follows.
I want to create the following URL:-
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