<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/basictasks/000058" xml:lang="zh-cn">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">筛选中使用的运算符</Title>
		<Keyword ContextSensitive="No"><Level1>筛选</Level1>
			<Level2>运算符</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>条件</Level1>
			<Level2>筛选</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>通配符</Level1>
			<Level2>筛选</Level2>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph class="Default">在定义筛选时，可以使用下列运算符为所筛选记录的字段指定条件：</Paragraph>
		<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><THEAD><TR><TD rowspan="1" colspan="1">运算符</TD>
					<TD rowspan="1" colspan="1">说明</TD>
					<TD rowspan="1" colspan="1">适用于数据类型的字段</TD>
				</TR>
			</THEAD>
			<TBODY><TR><TD rowspan="1" colspan="1">（完全）相等</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值与指定值完全相等。必须指定一个完整值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串、数字、日期/UTC、枚举</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">不相等</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值与指定值不相等。必须指定一个完整值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串、数字、日期/UTC、枚举</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">开头为</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段内容开头为指定的字符。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">开头不是</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段内容的开头不是指定的字符。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">等于或晚于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值与指定值相等或者大于指定值。可以指定某个搜索字符串的一部分。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">等于或早于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值与指定值相等或者小于指定值。可以指定某个搜索字符串的一部分。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">晚于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值大于指定值。可以指定某个搜索字符串的一部分。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">早于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值小于指定值。可以指定某个搜索字符串的一部分。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">包含</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段内容包含指定的字符。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">不包含</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段内容不包含指定的字符。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">在其中</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值与指定值之一相等。必须指定一个完整值或用逗号分隔的多个完整值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串、数字、枚举</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">不在其中</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值与任一指定值都不相等。必须指定一个完整值或用逗号分隔的多个完整值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字符串、数字、枚举</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">多于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值大于指定值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">数字</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">少于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值小于指定值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">数字</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">至少是</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值大于或等于指定值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">数字</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">最多是</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">字段值小于或等于指定值。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">数字</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">晚于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">存储在字段中的日期和时间晚于指定的日期和时间。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">日期/UTC</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">早于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">存储在字段中的日期和时间早于指定的日期和时间。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">日期/UTC</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">等于或晚于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">存储在字段中的日期和时间等于或晚于指定的日期和时间。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">日期/UTC</Paragraph>
					</TD>
				</TR>
				<TR><TD rowspan="1" colspan="1">等于或早于</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">存储在字段中的日期和时间等于或早于指定的日期和时间。</Paragraph>
					</TD>
					<TD rowspan="1" colspan="1">
						<Paragraph class="Default">日期/UTC</Paragraph>
					</TD>
				</TR>
			</TBODY>
		</TABLE>
	</GeneralSection>
	<RelatedTopics><SectionTitle>
                           相关主题
                        </SectionTitle>
		<RelTopic><Link href="/baanerp/tt/onlinemanual/100103" role="manual">在筛选值中使用通配符</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/basictasks/000014" role="manual">筛选概览</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/basictasks/000057" role="manual">使用筛选</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/basictasks/000059" role="manual">筛选中的条件示例</Link>
		</RelTopic>
	</RelatedTopics>
</ManualTopic>
