queries over looking special characters

  • Thread starter Query on description
  • Start date
Q

Query on description

I was trying to run a query where it will find a number even if the number
has special characters, ex: if one file has yj785 in one field and anther
has yj-785 in a field can i create a query that will bump them and find the
duplicates? right now when i run the query it will only find them if they
both are yj785. i would love any help i could get with this matter.

Thank you
 
M

Marshall Barton

Query said:
I was trying to run a query where it will find a number even if the number
has special characters, ex: if one file has yj785 in one field and anther
has yj-785 in a field can i create a query that will bump them and find the
duplicates? right now when i run the query it will only find them if they
both are yj785. i would love any help i could get with this matter.


You can use the Replace function to remove the extra
characters:

Replace(t1.field,"-","") = Replace(t2.field,"-"."")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top