Is there an easy way to identify data type mismatches?

[KristieLee1]

Hi. I'm wondering if there is an easy way to identify the items that are mismatched. The error 'data type mismatch' is vague. I know what it means, just don't know which items to check first in my query.

I'm looking for general ideas, or tips/tricks that this super user community might have.

Thank you!

PS..Skip, if you're lurking...your comments are appreciated.

 

[RiverGuy]

Comment stuff out to narrow it down.

 

[markros]

What is the exact error message? Somehow it sounds to me more like Visual FoxPro than SQL Server.

PluralSight Learning Library