Results 1 to 6 of 6

Thread: Newbie Help: Query Builder

Hybrid View

  1. #1
    Registered User nmadd's Avatar
    Join Date
    Jun 2007
    Location
    U.S.A.
    Posts
    1,676

    Re: Newbie Help: Query Builder

    Hi Dag,

    You can use wildcard characters.

    For example:
    %Potter% will match "Potter" anywhere in the title.

    Read a lot more about them here:
    http://office.microsoft.com/en-us/ac...881851033.aspx

    Good luck

  2. #2

    Thread Starter
    New Member
    Join Date
    Jun 2007
    Posts
    3

    Re: Newbie Help: Query Builder

    How would i go about making sure that the % sign is automatically added before and after the text to search for?

  3. #3
    Registered User nmadd's Avatar
    Join Date
    Jun 2007
    Location
    U.S.A.
    Posts
    1,676

    Re: Newbie Help: Query Builder

    Something like this:

    (WHERE Title Like '%' + ? + '%')

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width