troubleshooting Question

Simple statment with where clause returns no results

Avatar of DJ P
DJ PFlag for United States of America asked on
DatabasesMicrosoft SQL ServerSQL
2 Comments1 Solution70 ViewsLast Modified:
Ok don't know what I am missing here. I have a table (MasterDataFiles) in a sql database that has three fields. GroupName, MemberSamAccountName, and GroupDescription.

As a Test I imported two records from a flat file. I receive no errors on the import. Now here is my strange issue. In the server management studio if I run a simple select statement such as Select * from MasterDataFiles it returns both records. However if I use a where clause such as select * from MasterDataFiles where GroupName = 'ShareKnowledge' it returns no records.

I cannot figure out why. I have no type o's of any kind. Just for an additional test I tried the where clause on the remaining fields and got the same result. I don't know sql that well but I have never seen this before when working with one table for such a simple statement. What might I be missing?
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros