2 Replies Latest reply on Nov 9, 2018 5:49 AM by Matiss Seglins

    Potential Custom SQL Query (through MS SQL Server) bug

    Matiss Seglins

      Following line

       

      ,ISNULL(c.[TrafficLight], 'No TLS') AS [RAG TLS]
      

       

      Will return 'No TL' in the place of a NULL not 'No TLS'. It cuts off the last letter. If I put 2 spaces in between the words it will return 'No T' cutting off the last 2 letters.

       

      Whats going on here?