Hi Donald,
What I am guessing you are asking for is how to remove the characters 0-9 from a text field.
There are a number of ways to do this:
You can use the STRTRAN() function
Replace myfield With StrTran(myField,"1","")
of you can loop through the string on character at a time and use the ISDIGIT()
function:
lcString = mytable.myfield
lcOutPut = ""
For x = 1 to Len(lcString)
If Not IsDigit(Substr(lcString,x,1))
lcOutput = lcOutput + Substr(lcString,x,1)
Endif
EndFor
Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.