2 Replies Latest reply: Apr 17, 2012 4:59 AM by Mark Boomer RSS

    Using hex value in load script

      I want to use this where clause in a script when loading data from a SQL table
      WHERE Create_Date > '2012-01-01' AND ID = '0000000000001D5E';
      I've checked the hex value in the table and its oorrect but this statement doesn't return any values.
      I've created a list box and displayed the ID field and I can filter on this value and I also copied the cell value to paste in to the above statement.
      Any ideas why this fails to return any records...the date bit works correctly on its own