I am trying to create a query that will include HTML code for a link for a datagrid that I've got. However, I'm getting the error, "Truncated incorrect DOUBLE value" when I execute the following query:
'<a href=CamperSelItems.aspx?ID=' + CAST(ID AS Char) + '>Select Items</a>' AS ItemLink
If I replace the CAST(ID AS Char) statement with 1, and remove the quotes around it ('<a href=CamperSelItems.aspx?ID=1>Select Items</a>') it works just fine. So, I know that it's the ID field, and how I'm trying to get that to be part of the link that it's got a problem with. So, what is the correct way to do this?