7 Replies Latest reply: Oct 7, 2011 6:21 AM by Kaushik Solanki RSS

    Downloading from SQL Server 2008

      Hi,

      I'm new in QV and hope you can help me with the following issue.

      I'm connecting to SQL Server using OLE DB Provider.

      This is my SELECT Statement:

       

      SELECT

          PROJID

        FROM "Kom50_Test".dbo.PROJTABLE

       

       

      The value in one of rows is '00001.00'. But it is displaying as '00001' (Zeroes after dot are trimmed).

      If I'm using WHERE clause

      SELECT

          PROJID

        FROM "Kom50_Test".dbo.PROJTABLE

      WHERE PROJID = '00001.00'

      the same value is displaying as '00001.00'.

      How can I get correct value in the result of first statement?

       

      Thanking you.