<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Actually tried it with the commas, same effect. <div><br></div><div><br><div><div>On Nov 5, 2009, at 2:57 PM, Magnus Enger wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><br><br><div class="gmail_quote">2009/11/5 Erik Lewis <span dir="ltr"><<a href="mailto:elewis@ngrl.org">elewis@ngrl.org</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div style="word-wrap: break-word;">Been playing with this for awhile<div><br></div><div><div style="margin: 0px;">SELECT CONCAT('<a href="http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29" target="_blank">http://images.amazon.com/images/P/'isbn'.01.TZZZZZZZ.jpg')</a> FROM isbn_experiment LIMIT 10;</div> </div></div></blockquote><div><br>I think you may need som commas in the parentheses: <br><br>SELECT CONCAT('<a href="http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29" target="_blank">http://images.amazon.com/images/P/', isbn, '.01.TZZZZZZZ.jpg')</a> FROM isbn_experiment LIMIT 10;<br> <br><a href="http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat">http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat</a> ;-) <br><br>Regards, <br>Magnus Enger<br><a href="http://libriotech.no">libriotech.no</a><br> </div></div></blockquote></div><br></div></body></html>