Home Forums Article Discussions Article Discussions by Author Discuss content posted by adam haines Custom Pagination in SQL Server 2005 RE: Custom Pagination in SQL Server 2005

  • January 7, 2009 at 11:28 am

    #922769

    TheSQLGuru (1/7/2009)

    ...If you never passed in a NULL value then the CASE is surperfluous, right?..

    No, zero length string plays the role of NULL. That is if the parameter is zero length then grab all the records (sort of).