Crystal Reports XI: Using Wilcards with the Select Expert

[Former Member]

I have a field with 10 numbers. There are several of them that start with three numbers and end in all zeros. I want to make sure these are not in my report. I have been successfully able to do this using the select expert, but it requires a lot of manual entry:

{@Phone Number} <> "4090000000" and

{@Phone Number} <> "2810000000" and

{@Phone Number} <> "8320000000" and

{@Phone Number} <> "5120000000" and

{@Phone Number} <> "9999999999" and

{@Phone Number} <> "9760000000" and

{@Phone Number} <> "9360000000" and

{@Phone Number} <> "6010000000" and

{@Phone Number} <> "8150000000" and

{@Phone Number} <> "7130000000"

I need to find a way to do this without having to enter each code by itself. I tried using a wilcard, but it appears that I am not using it correctly.

{@Phone Number} <> "***0000000"

Please help. Thanks!

[Former Member]

Nevermind Just needed a simple:

not ({@Phone Number} like "*0000000")