Hi,

I have to increment Hexadecimal values which is of type NVARCHAR.
for Eg. 123A
This value has to be incremented 6 times.
as
123B
123C
124D
124E
124F
1250

I would appreciate if get some help.

Thanks & Regards
BindhuM

Can you store binary instead? Makes it lots easier to increment

I forget the details.. the manuel should be able to help
it should be possible to cast the hex value to an integer do your arithmatic and save the resultant value using the hex function

you could also do a similar approach depending on your front end
IIRC you can also directly assign hex values to intger datatypes (presumably integer and biginteger

Is there a reason that you don't store this as an integer or decimal value which would make your task much easier? Do you need to produce each of the six values, or only the final value? What is your input range (largest and smallest values)?

-PatP