Unclosed Quotation mark

Question

User-797751191 posted

Hi

  IN below line i am getting above error

td = +'<a href=''http://localhost:1501/test.aspx?No='+CAST(@ENo AS varchar(10)) + '>''

Thanks

Answer 1

User753101303 posted

Hi,

The last '' is a single quote in your string and you need to add a 3rd one to really close the string. Anyway it is misplaced (should be before the > character):

SELECT '<a href=''http://localhost:1501/test.aspx?No='+CAST(@ENo AS varchar(10)) + '''>'

Edit: or it could be clearer to use double quotes ie :

SELECT '<a href="http://localhost:1501/test.aspx?No='+CAST(@ENo AS varchar(10)) + '">'

Answer 2

User-1174608757 posted

Hi jsshivaik,

According to the error message, it shows that you have a problem with the use of quotes. You could see that you use a symbol ' at start, but your string   end up with " .

So as  PatriceSc said , you should modify your string and make your format correct. I hope it could help you.

Best Regards

Wei