sql server lead function

Very similar to the Lag() function that provides a previous record value is the Lead() function which provides the opposite