select next alpha character 1

[skicamel]

I've got a much larger text that I just about posted. If need be, I'll post that, but I think my issue would be solved by one little hurdle.

How would one go about this...

set @var = 'A'
set @var2 = @var + 1

...and have the result for @var2 be the letter B ?

Assume everything is in context, all the variables are declared properly, etc... I'm just hoping to figure out how to increment an alpha character by one.

Any ideas? Any gurus (ahem, Terry) have a solution for this?

 

[tlbroadbent]

Select @var2=char(ascii(@var)+1) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[skicamel]

Are you hiring, Terry?

Heh heh. You rock. Thanks (yet again).

Dan

 

[skicamel]

By the way, do you ever sleep?

 

[tlbroadbent]

I'm sleeping now! %-) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[skicamel]