Yes. :0)

SELECT CAST(LEFT(Number, PATINDEX('%[-,/\@#$%^!&*()+A-Z]%', Number + 'A')-1) AS int), Number FROM 
occ_main WHERE CAST(LEFT(Number, PATINDEX('%[-,/\@#$%^!&*()+A-Z]%', Number + 'A')-1) AS int) BETWEEN 300 and 315

>Tracy,
>
>It will indeed work. Both, what you have there and what I posted do the same thing. I was confused about what the solution below was accomplishing exactly. Although, shouldn't your query below use the same pattern in both the select and where clauses?
>
>Chad
>
>>This seems to work:
>>

>>SELECT CAST(LEFT(Number, PATINDEX('%[-,A-Z]%', Number + 'A')-1) AS int), Number FROM occ_main
>>   WHERE CAST(LEFT(Number, PATINDEX('%[-,/\@#$%^!&*()+A-Z]%', Number + 'A')-1) AS int) BETWEEN 302 AND 390
>>

>>I updated number in the table so that a few records contained the value of 311-3B or 308A in the number field and when I ran the above query it returned them as well as 302-309 plain values.
>>
>>It returned:
>>
>>

>>(no column name)   number
>>302                  302
>>308                  308A
>>311                  311
>>311                  311-3B
>>312                  312
>>308                  308
>>

>>Etc which is correct.