Jeff,
It's the "6X" that is tripping you up.
UniData interprets this as a string of a literal "429", followed by a 6
character string (6X), followed by an "H".
Try putting it in quotes and see if that gives you the result you're
looking for.
P. Michael Logue
U2 Technical Support Engineer &
U2 Products Service Planner
IBM Certified Solutions Expert in U2 Application Development
IBM Certified U2 UniData Administration
IBM Information Management Division, Software Group
Phone: 303-773-7846
Tie Line: 656-7846
Email: [EMAIL PROTECTED]
www.ibm.com/software/data/u2/support
Open, Query, Update, Search - Online!
Jeffrey Butera
<[EMAIL PROTECTED]
e.edu> To
Sent by: <[email protected]>
[EMAIL PROTECTED] cc
stserver.u2ug.org
Subject
[U2] Unidata Pattern Lookups
10/06/2005 09:30
AM
Please respond to
u2-users
We have an application I wrote which records parking stickers for the
college.
It saves data using the person's ID and license plate (with certain bad
characters removed). However SELECTS against the file occasionally fail if
the license plate string is interpreted by Unidata as a pattern.
For example:
:LIST H08.PS.VEHICLES WITH @ID LIKE ...4296...
0717266*4296XH
1 record listed
:LIST H08.PS.VEHICLES WITH @ID LIKE ...4296XH
No records listed.
I'm not terribly familiar with pattern matching in Unidata, but am
wondering
if there's a UDT option I can switch off in certain situations to avoid
this.
(I'm looking thur my UDT Options Command Ref and can't see anything yet...)
Our Public Safety office is irritated because searching on an exact plate
sometimes fails yet a partial plate succeeds.
--
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556
"...our behavior matters more than the beliefs that we profess."
Elizabeth Deutsch Earle
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
pic25615.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
