select (case when collectionImg = '' then '' else '<img src=' collectionImg '><br>' end) as collectionImg
Basically I want it to check to see if there is a collectionImg. If there is, build the html for me, if not do nothing. Everything works except it doesn't display the collectionImg variable. How do I need to format that part (collectionImg) to get it to work?