Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there a way i can use a CHR() in a wildmatch where clause?
I am trying to find data with a ^ in it , but when i try
Where Wildmatch([Field Name],'*^');
i get nothing back.
I am guessing it doesnt like the ^ so i was wondering if i could use the CHR() istaed '(CHR(93)'
does anyone know how i would write that?
Have you tried index instead?
WHERE Index(FIELD, '^');
or
WHERE Right(FIELD,1) = '^';
Have you tried index instead?
WHERE Index(FIELD, '^');
or
WHERE Right(FIELD,1) = '^';
Thats great, i didnt try index() Thanks very much!
May be try this?
WildMatch([Field Name], '*'&$(=Chr(94))&'*')
Were looking looking for solution))