Make Query Ignore Special Characters

[NadiaVKhan]

No. I have a table called tblInformation.

The first field is called CaseNumber. The second is CustomerName. The third is Home Phone

I can have the following data:



CaseNumber CustomerName Home Phone
1222 James Smith 555-999-6565
1222 John Adams 555-888-9898
1222 Amber White 555-665-5555
1223 Joe Biden (555)505-5404

[davegri]

CaseNumber CustomerName Home Phone
1222 James Smith 555-999-6565
1222 John Adams 555-888-9898
1222 Amber White 555-665-5555
1223 Joe Biden (555)505-5404

That table schema does not match up with either query in post #23 or post #12.
We need to see the SQL of the query. Also don't see much point in blanking out the field names.

[davegri]

This works.
Here's the query Grid.

Attachment 28105

Here's the result
Attachment 28106

Here's the SQL
SELECT tblInformation.CaseNumber, tblInformation.CustomerName
FROM tblInformation
WHERE (((getnumbers(CStr([Home Phone]))) Like "*5404*"));

[Bulzie]

So it works?

[davegri]

Works as posted by me. Should work for OP.

[NadiaVKhan]

Thank you for the help everyone. I tried the SQL exactly how Davegri did it. But I am unable to run the query as I get the error: (Invalid Use of Null).

I also get this error when I try it straight from design view (which didnt happen before)

[andy49]

Can you post your database on here Nadia even with made up data. It would certainly help us solve it


Sent from my iPhone using Tapatalk

[NadiaVKhan]

I actually just make an example blank database to send to you. And it worked..

I think I figured it Out. I removed all Nulls from my query

[NadiaVKhan]

Thank you everyone!

[andy49]

What about the null values in future? Maybe a slight alteration to the function.


Sent from my iPhone using Tapatalk