title: Teradata LIKE operator without wildcard?
body: <p>In Oracle, the LIKE operator can be used either with or without a wildcard.
  For example "where name like 'SMITH'" will return rows where the name column is exactly 'SMITH',
  and "where name like 'SMITH%'" will return rows where the name column begins with 'SMITH' followed by 0 or more other characters.</p>
  
  <p>However in Teradata, "where name like 'SMITH'" returns nothing.  Does ANSI standard not specify behavior for the LIKE operator if used without a wildcard?</p>
  
  <p>Boolean algebra says 'SMITH' like 'SMITH' is true.  Oracle behaves this way; Teradata does not. Can Teradata SQL be tweaked to enable the LIKE operator to work both with and without wildcards?</p>