<p>I have a SQL statement that looks like:</p>

<pre><code>SELECT [Phone]
FROM [Table]
WHERE
(
    [Phone] LIKE '[A-Z][a-z]'
    OR [Phone] = 'N/A'
    OR [Phone] LIKE '[0]'
)
</code></pre>

<p>The part I'm having trouble with is the where statement with the "LIKEs". I've seen SQL statements where authors used <code>like</code> statements in the way I'm using them above. At first, I thought this might be a version of Regular Expressions but I've since learned. </p>

<p>Is anyone familiar with using like statements in such a way. Note: the "N/A" is working fine. </p>

<p>What I need to match is phone numbers that have characters. Or phone numbers which contain nothing but zero.</p>

Check
here
.
[] matches a range of characters.
I think you want something like this:
```
```
SELECT [Phone]
FROM [Table]
WHERE
(
    [Phone] LIKE '%[A-Z]%'
    OR [Phone] LIKE '%[a-z]%'
    OR [Phone] = 'N/A'
    OR [Phone] LIKE '0'
)
```
```