SELECT * FROM [case] WHERE caseno LIKE '%]%'

Ran this with no results found, and now that I think about it this

I found this field has the - in it as...

I think it has an occasional alpha character.  Thank You.

Apparently, the orginal question should have been:

How do we turn on implicit conversions in/on SQL Server 2000?

Thank You

thank you for the information.  I am curious why do you think in SQL Server 7.0 it allowed the  no quotes for that type of field?

Thanks Again,

Sincerely,

Kim Powell

VarChar(12) is the data type for the column/field on both servers

and  SQL Server 2000    DBCC USEROPTIONS (cannot get to server 7):

Set Option Value

textsize                   ...