I have Nvarchar column in which i am storing Series no
and i increment it as max(DocNO)+1 to get next number in series
but it has problem after 9 for 10 it also giving max as 9
what is the problem and solution. Do i need to use cast()?

Vivek wrote:
Why are you storing what clearly appears to be a numeric value in a
character-based column? Consider using an INT column for storage. You
can cast the column to an int but that doesn't address the design
issues.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com

run the code below and you will understand the problem

declare @1 nvarchar(5),@2 nvarchar(5)
select @1 = '1000'
select @2 ='9'
if @1 > @2
select 'yes'
else
select 'no'
go
declare @1 nvarchar(5),@2 nvarchar(5)
select @1 = '1000'
select @2 ='09'
if @1 > @2
select 'yes'
else
select 'no'

and yes use an identity instead

http://sqlservercode.blogspot.com/



"David Gugick" wrote: