_ Sql code to increment letter variables

				
--**************************************
-- Name: _ Sql code to increment letter variables
-- Description:To increment letter codes.
-- By: Duane Warsham
--
-- Assumes:This will simply increment a letter code from "C" to "D" with one pass. To customize the incremental process, set the @letters string to whatever you need, and could also adjust the incremental step.
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=865&lngWId=5--for details.--**************************************

Declare @letters as char(26) 
Set @letters= 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
declare @letterin char(1)
declare @position int
-- this is the initial variable to increment
set @letterin = 'C'
-- find the letter in your preset string
Set @position = CharIndex(@letterin,@letters,1)
print @position
-- increment to the next position desired
Set @position = @position + 1
-- get the new letter by the new position number
Set @letterin = Substring(@letters,@position,1)
-- here is your new letter
print @letterin