Home Forums SQL Server 2005 T-SQL (SS2K5) Error converting data type varchar to numeric in CASE statement RE: Error converting data type varchar to numeric in CASE statement

  • I've just skimmed this thread so apologies if this is not what you're looking for. But why not adjust the WHERE clause as follows:

    where SomeVal2 = 'ABC' or SomeVal is not null

    I think it's equivalent.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.