Re: Text feild check for pattern or if last 5 are numeric?
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Thu, 15 Oct 2009 14:37:18 -0700, Billp <Billp@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
If Me!SER_Exists Like ">L00000" Then 'fits the text pattern
Input masks use one syntax. LIKE wildcards use a different syntax.
The field does not contain a > character (that just forces the letter to
display in upper case, even if it's stored in lower).
Use a criterion
LIKE "[A-Z]#####"
will match strings containing a letter (upper or lower case, it's not case
sensitive) followed by five numeric digits.
--
John W. Vinson [MVP]
.
Relevant Pages
- text editor component (seeking design advice)
... TEXT FOLDING ... i do not know how to store the character data. ... i'll have to parse even the folded text - for syntax highlighting ...
(alt.comp.lang.borland-delphi) - Re: The fallacy of strengthened liars paradox.
... have the same syntax. ... However, in English, the same expression, character ... no real difference. ... What does it mean to me to have contradictory ...
(sci.logic) - Re: Trying to embed new syntax into the reader
... This allows the usual infix function call syntax fto be co-opted, ... hinted is to put in the readtable as many reader macros as needed to be ... you'd set a reader macro on each character. ... parser as usual, which is rather trivial to write with a parser ...
(comp.lang.lisp) - Re: Again: Please hear my plea: print without softspace
... >> character instead of a ',' to alter the behavior of print. ... Changing the behavior of print when a syntax ... print statement is a sort of magic syntax as it is; ... it could be some other character. ...
(comp.lang.python) - Re: "Select" & "Order By" OK- WHERE Doesnt Work !
... i'm sure the error messages now ... their syntax. ... > It's always useful to display your sql statements especially when you build ... That's why using the or dieto display the sql and the ...
(comp.lang.php) |
|
