#DateForumTypeThreadPost
424 Sep 2015 @ 06:29 PDTToolsTopicHyperlink in SQL Assistant Answerset Grid?You know how SQL Assistant will display a hyperlink in the answerset grid for BLOBs and CLOBs?  Is there any way to do that yourself?  I have file locations stored in a table in a VA...
308 Aug 2012 @ 09:51 PDTToolsReplyUnable to open History table - SQL Assistant 13 What was the solution for this?
227 Oct 2010 @ 07:08 PDTDatabaseReplycoalesce and format functionI just tried it in V13 SQL Assistant and I don't get the NULL. When Field is NULL I'm getting 0. But your format statement will suppress the zero so all you see is spaces. Try ZZZ,ZZZ,Z9 instead...
127 Oct 2010 @ 06:58 PDTDatabaseReplyQuery on JoinsIf I understand the question correctly, you would LEFT JOIN table1 to table2 and table3 on p_no, then use the COALESCE() function on the address columns so that table2's columns are chosen when the...