CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Angry Search within a field

    I have a field named {calls.proble}

    I want to search within that field for a perticular group of text characters and only show those records containing the searched text.

    I.e the record might display "the quick brown fox jumped over the lazy dog"
    I want to show only those records which contain the word "jumped"

    Any help please!

    Thanks

  2. #2
    Join Date
    Jul 2005
    Posts
    1,083

    Re: Search within a field

    You could use a Record Selection Formula with InStr function, as :
    Code:
    If Instr({calls.proble},"jumped")<>0 then True else False
    Last edited by jggtz; April 3rd, 2009 at 10:07 AM.

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

Featured