Hmmm That might work. Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx> CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium. From: Howard Latham [mailto:howard.latham@xxxxxxxxx] Sent: Thursday, December 03, 2009 9:25 AM To: Taylor, Chris David Cc: Oracle-L@xxxxxxxxxxxxx Subject: Re: Increment an alphabetic variable in a PL/SQL loop? Couldnt you just assign using a the sql chr function 2009/12/3 Taylor, Chris David <ChrisDavid.Taylor@xxxxxxxxxxxxxxx<mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx>> Hey how can we increment an alphabetic variable in PL/SQL? Let's say I have var1 = 'A' for the first pass, but for the second pass, I want it to autoincrement to var1='B' and ultimately to 'Z'. I'm searching but its hard to find the right search terms to give me what I want. Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx> CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium. -- Howard A. Latham