Title pretty much says it. I want to join to a table that has entries like Sand and Sandstone, or Chert and Chert with striations. The table I am join to has these expressions as the leading text in a longer text field, so I am joining with trailing wildcards. If my table has the longer entry, I want it to join on that, but if it has the shorter variation, I still want it to join. Is there a way to tell SQL Server to join on the longest possible match?