按非字母数字字符选择 [英] Selection by non-alphanumeric characters
问题描述
嗨
如何使用选择查询在字段
中选择包含非字母数字字符的记录？
谢谢
问候
Hi
How can I select records that have non-alphanumeric characters in a field
using a select query?
Thanks
Regards
推荐答案
" John" <乔** @ nospam.infovis.co.uk>在留言中写道
新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl
嗨
如何使用选择查询在
字段中选择包含非字母数字字符的记录？
Hi
How can I select records that have non-alphanumeric characters in a
field using a select query?
WHERE [SomeField] Like" * [！0-9A-Z] *"
-
Dirk Goldgar，MS Access MVP
www.datagnostics.com
（请回复新闻组）
WHERE [SomeField] Like "*[!0-9A-Z]*"
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
从选择中排除 - （连字符）的任何方法吗？
谢谢
问候
" Dirk Goldgar" < dg@NOdataSPAMgnostics.com>在消息中写道
news：OK ************* @ TK2MSFTNGP11.phx.gbl ...
Any way to exclude - (hyphen) from selection?
Thanks
Regards
"Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
news:OK*************@TK2MSFTNGP11.phx.gbl...
" John" <乔** @ nospam.infovis.co.uk>在消息中写道
新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl
嗨
如何使用选择查询在
字段中选择包含非字母数字字符的记录？
Hi
How can I select records that have non-alphanumeric characters in a
field using a select query?
WHERE [SomeField] Like" * [！0-9A-Z ] *
- Dirk Goldgar，MS Access MVP
www.datagnostics.com
（请回复新闻组）
WHERE [SomeField] Like "*[!0-9A-Z]*"
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
任何使用方式！ （字面意思）和过滤器中的{space}？
非常感谢
问候
Dirk Goldgar < dg@NOdataSPAMgnostics.com>在消息中写道
news：OK ************* @ TK2MSFTNGP11.phx.gbl ...
Any way to use ! (literally) and {space} in the filter?
Many Thanks
Regards
"Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
news:OK*************@TK2MSFTNGP11.phx.gbl...
" John" <乔** @ nospam.infovis.co.uk>在消息中写道
新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl
嗨
如何使用选择查询在
字段中选择包含非字母数字字符的记录？
Hi
How can I select records that have non-alphanumeric characters in a
field using a select query?
WHERE [SomeField] Like" * [！0-9A-Z ] *
- Dirk Goldgar，MS Access MVP
www.datagnostics.com
（请回复新闻组）
WHERE [SomeField] Like "*[!0-9A-Z]*"
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
这篇关于按非字母数字字符选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
