|
-
Apr 22nd, 2006, 04:01 AM
#1
Thread Starter
Fanatic Member
writing SQL statement
Hi
I have an SQL table that contains a Flag field type int(allow null) and many other fields
Field Type
Flag int (allow null)
....
If I don't assign a value to Flag it appears<NULL>
I want to write an SQL statement that returns to me all records having an int value in the Flag
For example
ArticleID Title Category Flag
12 hi Economics <NULL>
13 H R U LAW 1
14 GUG LAW 5
15 HUN POL <NULL>
So I want the SQL statement to return only the 2records having ArticleID=13 and 15 because the other 2 records are not assigned a value in the Flag field
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|