5 Replies Latest reply on Sep 3, 2008 1:05 PM by darbus23

    Find first 3 letters with Form search?

    newportri Level 1
      Greetings

      I have a search form in which the user types the first 3 letters of a word - the results should display only those words that begin with the letters.

      What would the correct SQL format be to accomplish this?

      WHERE myword LIKE '%#Trim(FORM.Keyword)#%' ?

      Thanks in advance.