FileBound
      Back to home
      1. IMS Knowledge Base
      2. Code Snippets
      3. FileBound

      SQL Script to Check for a Trailing space in Separators and Dividers for all FileBound Projects

      Script to provide a count of Dividers that have a trailing space in any of your FileBound projects:

      Select Count(DividerName) from Documents where Status = 1 and DividerName like '% '

      Script to provide a count of Separators that have a trailing space in any of your FileBound projects:

      Select Count(Separator) from Documents where Status = 1 and Separator like '% '