i have a int column as Custid

initally value is balnk.

but i have set the default value when creating the field as 0

i need to increment the max Custid value

but if its null i need it be 0 so incrementing it would be 1

select isnull(Custid,0)+1 as ID from TABLE1

i have the Custid field blank with defualt value as 0

but when i use the abobe query i dont get 1

select isnull(Custid,0) as ID from TABLE1 i dont get 0