在MS Access查询中检查字符串模式 [英] Checking string pattern in MS Access query

问题描述

我在MS Access中有以下查询

I have the following query in MS Access

SELECT CREAT.Subject, CREAT.CREAT, (IIf([CREAT.TargetDays]=".",".",Val([CREAT.TargetDays])*24)) AS TargetDays
FROM CREAT
WHERE IsNumeric(CREAT.TargetDays) AND IsNumeric(CREAT.CREAT)
ORDER BY Subject, Val([CREAT.TargetDays]);

我想检查一个名为FolderName的字段是否是一个字符串，如D18，D1等.这意味着第一个字符应为'D'，紧随其后的是数字.有人可以告诉我如何做到这一点.

I would like to check if a field called FolderName is a string like D18, D1 etc.. which means the first character should be 'D' which is immediately followed by digits. Could someone please tell me how to accomplish this.

推荐答案

尝试一下

[FolderName] Like 'D[0-9]*'

这篇关于在MS Access查询中检查字符串模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！