Finding Trailing Spaces

• Steve Jones - SSC Editor

  SSC Guru

  Points: 743561

  More actions

  October 5, 2026 at 12:00 am

  #5031942

  Comments posted to this topic are about the item Finding Trailing Spaces

• Carlo Romagnano

  SSC-Insane

  Points: 22959

  More actions

  October 5, 2026 at 5:33 am

  #5056541

  SQL string comparison always ignores trailing spaces.

  Therefore, fld1 <> TRIM(fld1) is equivalent to fld1 <> fld1.

  A comparison technique for detecting trailing spaces is to use LIKE '% '

  Searching for trailing spaces when the type is CHAR makes no sense, unless you are looking for a string shorter than the length of the cell.