在文本搜索中使用通配符 [英] 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屋!
查看全文