Very Computer

Hi,

I'm looking for simple way to convert a character to an integer through a
SP. For example, I want to convert A-Z to -26 to -1 where A would be -26, B
would be -25, and so on.

Is there an easy way to do this without a table? Also, how can I call this
SP from another SP?

Thanks.

Khurram

You can use the ASCII function to return the Base 10
numeric value of the character.  Then just adjust the
number up or down as needed

Try this:

SELECT ASCII('A')

ASCII is the reciprical of CHAR()

SELECT CHAR(ASCII('A'))

Quote:>-----Original Message-----
>Hi,

>I'm looking for simple way to convert a character to an
integer through a
>SP. For example, I want to convert A-Z to -26 to -1 where
A would be -26, B
>would be -25, and so on.

>Is there an easy way to do this without a table? Also,
how can I call this
>SP from another SP?

>Thanks.

>Khurram

>.

SELECT ASCII('A')-91

--
David Portas
SQL Server MVP
--