Thanks Jack for pointing in the right direction 🙂

Things starting to make much more sense now. A little quote I found from one of the blogs...

"The placement of predicates in...

Thanks Kabi and Akeel... Your suggestions definitely work...Just that I am interested in finding out what is wrong with my initial attempts.

Thanks Kabi and Akeel... Your suggestions definitely work...Just that I am interested in finding out what is wrong with my initial attempts.

Yes, I am using C#2008 express edition. But I dont think that Microsoft will cut down on such a prominent feature in express editions.

Yes I tried that. But I only have Microsoft SQL Server Compact 3.5 and not Microsoft SQL Server in the Data source list box. The other options I have...

Like all other I coudnt help but say how difficult it was to remember the connection string. The datalink object comes in real handy.

Thanks you.

Hi,

That really explains why my query werent pulling out any records...

Well I was able to solve the problem by modifying it as below:

select phonenumber

from ttemp

where phonenumber

not in

(

...

Hi,

I am having problems with my queries which I definitely think is because of null values. This is what I want to do:

Find out a list of phone numbers that...