S&M NuTec, the company that produces Greenies, furnished us a copy of the complete statement they sent to KIRO-TV, which touches on some of the cases discussed: Our Commitment to Healthy Pets Our company was founded and is staffed by people who are deeply passionate about pets and their welfare.
This SQL Server tutorial explains how to use the LEAD function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the LEAD function is an analytic function that lets you query more than one row in a table at a time without having to join the table to itself.
Example in SQL/Queries. You can also use the Len function in a query in Microsoft Access. This query will return the length of the CategoryName field and display the results in a column called Expr1. You can replace Expr1 with a column name that is more meaningful. The results would now be displayed in a column called NameLength.