4 Replies Latest reply on Jun 24, 2004 2:15 PM by Franco

    CHAR and Blanks

    cyberdoc Newbie

      Hi,

      is it possible to create a PK finder method to find values with the SQL type CHAR, without the filling blanks?

      Example:

      IS CHAR Value = 'TEST '

      SELECT VALUE FROM TEST_TABLE WHERE VALUE = 'TEST';
      -> result null

      SELECT VALUE FROM TEST_TABLE WHERE VALUE = 'TEST ';
      -> found one



      thx

      Michael