<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/basictasks/000078" xml:lang="en">
   <Header>
      <Title>To use wildcard characters for filter values</Title>
      <Keyword type="header" order="d1e507110">
         <Level1>filters</Level1>
         <Level2>to use wildcard characters for</Level2>
      </Keyword>
      <Keyword type="header" order="d1e507115">
         <Level1>wildcard characters</Level1>
         <Level2>for filters</Level2>
      </Keyword>
   </Header>
   <GeneralSection>
      <SectionTitle>Wildcard characters</SectionTitle>
      <Paragraph>When you define a filter value with the condition <GUIRef href="/baanerp/tt/domains/adv.fopr#alfa.like" role="option">Contains</GUIRef> or <GUIRef href="/baanerp/tt/domains/adv.fopr#alfa.not_like" role="option">Does Not Contain</GUIRef>, the value can include the wildcard character combination .*.
		This character combination represents any number of any character.</Paragraph>
      <Paragraph>If the condition is other than <GUIRef href="/baanerp/tt/domains/adv.fopr#alfa.like" role="option">Contains</GUIRef> or <GUIRef href="/baanerp/tt/domains/adv.fopr#alfa.not_like" role="option">Does Not Contain</GUIRef>, the value cannot include the wildcard character combination
		.*.</Paragraph>
      <ExampleSection>
         <SectionTitle>Example</SectionTitle>
         <Paragraph>This table illustrates the usage of wildcards in a
		  filter.</Paragraph>
         <TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated">
            <TBODY noTR="8">
               <TR no="1" isLast="false">
                  <TH rowspan="1" colspan="1">Session</TH>
                  <TD colspan="2" rowspan="1">
                     <GUIRef href="/baanerp/tc/com/tccom0101m000" role="session">Employees - General (tccom0101m000)</GUIRef>
                  </TD>
               </TR>
               <TR no="2" isLast="false">
                  <TH rowspan="1" colspan="1">Field Name</TH>
                  <TD colspan="2" rowspan="1">Employee</TD>
               </TR>
               <TR no="3" isLast="false">
                  <TH rowspan="1" colspan="1">Condition</TH>
                  <TH style="width:7em;" rowspan="1" colspan="1">Value</TH>
                  <TH rowspan="1" colspan="1">Displays all employees of which the Employee field:</TH>
               </TR>
               <TR no="4" isLast="false">
                  <TD rowspan="1" colspan="1">contains</TD>
                  <TD rowspan="1" colspan="1">AA</TD>
                  <TD rowspan="1" colspan="1">contains AA</TD>
               </TR>
               <TR no="5" isLast="false">
                  <TD rowspan="1" colspan="1">doesn't contain</TD>
                  <TD rowspan="1" colspan="1">AA</TD>
                  <TD rowspan="1" colspan="1">does not contain AA</TD>
               </TR>
               <TR no="6" isLast="false">
                  <TD rowspan="1" colspan="1">contains</TD>
                  <TD rowspan="1" colspan="1">H.*</TD>
                  <TD rowspan="1" colspan="1">starts with
				  H</TD>
               </TR>
               <TR no="7" isLast="false">
                  <TD rowspan="1" colspan="1">doesn't contain</TD>
                  <TD rowspan="1" colspan="1">H.*</TD>
                  <TD rowspan="1" colspan="1">does not start with
				  H</TD>
               </TR>
               <TR no="8" isLast="true">
                  <TD rowspan="1" colspan="1">contains</TD>
                  <TD rowspan="1" colspan="1">.*O.*N.*</TD>
                  <TD rowspan="1" colspan="1">contains O and, one or
				  more positions later, N <List>
                        <ListIntro>Sample matches:</ListIntro>
                        <ListItem>JOHN</ListItem>
                        <ListItem>LORRAINE</ListItem>
                        <ListItem>RODNEY</ListItem>
                     </List>
                  </TD>
               </TR>
            </TBODY>
         </TABLE>
      </ExampleSection>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/basictasks/000014" role="manual">Overview of filters</Link>
      </RelTopic>
      <RelTopic>
         <Link href="/baanerp/basictasks/000057" role="manual">To use filters</Link>
      </RelTopic>
      <RelTopic>
         <Link href="/baanerp/basictasks/000059" role="manual">Examples of conditions in filters</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>