Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Given a letter ascertain next letter in alphabet

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-24 : 21:44:36
garrett writes "Is there a function in SQL2000 where, given a letter in the alphabet, the next letter can be returned.

i.e. given letter "x" how do I get letter "y" returned as a result ?"

Tigger
Yak Posting Veteran

85 Posts

Posted - 2002-02-24 : 21:53:58
char(ascii(char_value)+1)

Go to Top of Page
   

- Advertisement -