I have a SQL 7 View with this code:
SELECT BannerID, Image, URL, Shown, Clicked,
'<a href="RedirectMe.asp?URL=' + URL + '&BannerID=' + BannerID
+ '"target="_blank"><img src="' + Image + '"></a>' AS Banner
When I try to open this View I get the following error:
Syntax error converting the nvarchar value '<a
href="RedirectMe.asp?URL=admin.asp&BannerID=' to a column of data type int.
Would anyone have an idea how to solve this? I think I need to use CAST or
CONVERT but I am not sure how.