在文本搜索中使用通配符 [英] Using a Wildcard in a Text Search

问题描述

我在Access查询中有一个简单的if语句，但我无法使用通配符搜索。这是我的查询中的陈述。

IIf（[RECFROM] =" JOB"和[PROG] =" SEATTLE" And SHOP] =" * A *"，"SEATTLE"

我正在寻找在字符串中任何位置都有A的所有SHOP名称。使这个有效的正确语法是什么？SHOP是一个文本字段。

I have a simple if statement in an Access query but I can't get the wildcard search to work. Here is the statement in my query.

IIf([RECFROM]="JOB" And [PROG]="SEATTLE" And [SHOP] = "*A*","SEATTLE"

I am looking for all SHOP names that have an A anywhere in the string. What is the correct syntax to make this work? SHOP is a text field.

推荐答案

你好

你忘了喜欢。

Hello

You forgot the LIKE.

IIf([RECFROM]="JOB" And [PROG]="SEATTLE" And [SHOP] LIKE "*A*","SEATTLE")

希望这会有所帮助


Rob

Hope this helps


Rob

这篇关于在文本搜索中使用通配符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！