Alphanumeric values 2

Also one more question. We don't support xp_cmdshell at work. Is there another way to run win commands from SQL?

Take a look at this

declare @c char(1)
select @c ='A'
select @c,char(ascii(@c)+1)

Denis The SQL Menace
SQL blog:
Personal Blog:

Ascii convert letters to their ascii equivalent (which is an integer). You can add 1 to this integer, and then convert it ascii number back to a character.

Select Char(1 + Ascii('A'))



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

Thanks guys