>I need a serial # scheme that works like newid(), But uses Letters as well as numbers. Anyone have some code or know where I can get it.
>Oh i'm using vfp 5
>
> Thanks Kelly

---

This is only with A-Z :

function myAlpha && Haven't tried but supposed to work up to 26^128
lparameters tnValue && Convert tnvalue to Excel alpha notation
if tnValue = 0
	return ""
endif
if tnValue <= 26
 return chr(asc("A")-1+tnValue)
else
 return ;
   myAlpha(int(iif(tnValue% 26 = 0,tnValue - 1, tnValue) / 26)) + ;
   myAlpha((tnValue-1)%26+1)
endif

Cetin