Query Issue

[rockz]

I'm writing the query given below which should give 5 rows which has ParentFragmentId as NULL but I'm not getting any row. SELECT TOP (5) FragmentId, FragmentTitle FROM Fragments WHERE (ParentFragmentId = NULL) ORDER BY CreatedOn DESC

[Colin Angus Mackay]

Try:

SELECT TOP (5) FragmentId, FragmentTitle
FROM Fragments
WHERE (ParentFragmentId IS NULL)
ORDER BY CreatedOn DESC

---

Upcoming FREE developer events: * Developer Day Scotland My website | blog