Exclude characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I'd like to write a query that excludes particular characters. Can anyone
tell me how that would be done?

Thanks in advance,
Ellen
 
in the criteria pane enter something like:
like "*a*"
where a is the character you want to find.
 
Thank you for your help. I actually wanted to find, for instance, all
records with don't have an "a" in them. It's got to be something similar to
what you gave me.
 
Hi Ellen,
I actually wanted to find, for instance, all
records with don't have an "a" in them.
Click to expand...

SELECT * FROM tab WHERE INSTR(1,fld,'a',0)=0 (case sensitive)

or

SELECT * FROM tab WHERE INSTR(1,fld,'a',1)=0 (ignores case, would
exclude 'a' and 'A').

HTH,
Wolfgang
 
Ellen said:
I'd like to write a query that excludes particular characters. Can anyone
tell me how that would be done?
Click to expand...


Use a criteria like this under the field you want to check
for the characters a, p, q and z:

Not Like "*[apqz]*"
 
Back
Top