To find a match WHERE Field2 LIKE Format([Field1],"@@\/@@@@\/@@@@@@\/@@@") & "*" To find a non match WHERE Field2 NOT LIKE Format([Field1],"@@\/@@@@\/@@@@@@\/@@@") & "*" Or WHERE Mid(Field2,9) Like MID(Format(Field1,"@@\/@@@@\/@@@@@@\/@@@"),9) & "*" -- John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore
On Wed, 13 Feb 2008 11:08:00 -0800, Mary <Mary@discussions.microsoft.com> wrote: I have two fields that should match, but one includes special characters while the other does not. Example: Field1 00ABCD123456123 Filed2 00/ABCD/123456/123/SBZ I need to find records where these two fields don't match, either by changing the display of one of them, or a query to compare Field1
I have two fields that should match, but one includes special characters while the other does not. Example: Field1 00ABCD123456123 Filed2 00/ABCD/123456/123/SBZ I need to find records where these two fields don't match, either by changing the display of one of them, or a query to compare Field1 character 7-15 with Field2 characters 9-14, 16-18. Hope this makes sense. Can anyone
"Antoine Leca" <r...@localhost.invalid> wrote: Ennews:7a69ebc1-d045-4493-a9ad-c4141a1f3f4a@q77g2000hsh.googlegroups.com, Jun Woong va escriure: [6.4p3 where the term "white-space character" defined] The term "white-space character" is not just mentioned there, but defined, which means, whenever it is used in the standard it should be interpreted to refer to that definition
