Hello
I can't find solution in any books. I am doing an html concatenation in sql with sql columns:

Set HtmlReady =
'<H1><A HREF="http://' + LINK + '" target="_blank"><img src="c:\inetpub\wwwroot\OCVBUG_Book\images\' + IMAGESM +'" border="0" align="Center"></A></H1><H2><A HREF="http://' + LINK + '" target="_blank">' + Title + '</A></h2>

<DIV CLASS="SPONSORSLINK"><P>' + [BRIEFDESC]+'
<BR>
<BR><A HREF="http://book2.aspx?BookID=' + BookID +'" > Read more ... </A></P></DIV>'

I get the error:
Syntax error converting the varchar value '" > Read more ... </A></P></DIV>' to a column of data type int.

How can I include a convert in this code????
I don't want to write a separate code.

You need to CAST the BookID field to a varchar if you want to include it in the middle of that string
...<BR><A HREF="http://book2.aspx?BookID=' + CAST(BookID AS varchar) +'" > Read more ... </A></P></DIV>'