Basic Sql Question

[ss7thirty]

I have a field that is VarChar and I am wondering how to check if something is an exact match or not. It seems that the equal operator is not working for this type of field. I was wondering if there was a way to do this without having to use a like statement or if there is a way to make sure the like statement is an exact match because in this field I may have one record with '84' and one that is 'A-1234584'.

 

[TechGnome]

What do you mean the equal operator does not work..... That could mean any thing. As some one who deals with SQL all day long, I do know it DOES works.... so it leads me to ask, what is the data you are comparing, how are you comparing it, what did you expect to happen, and what really did happen?

-tg