>I have a table with over 1,000 records with the field description
>on the format below
>
>BM146
>SLV640HF
>SLV660HF
>SLV676
>SLV676UC
>SLV686HF
>SLV696HF
>SLV696UC
>
>I would like to space between numbers and letters
>
>BM 146
>SLV 640 HF
>SLV 660 HF
>SLV 676
>SLV 676 UC
>SLV 686 HF
>SLV 696 HF
>SLV 696 UC
>
>Note that it's hard because some has three letter as prefix
>and other have two letters. Other has sufix and not
>
>TIA
>
>Moises

Function PutSpaces
Lparameters tcStr
local lcNumber
lcNumber = Chrtran(tcStr,Chrtran(tcStr,'0123456789',''),'')
return Stuff(tcStr, At(lcNumber, tcStr), Len(lcNumber), ' '+lcNumber+' ')

Or a oneliner to use in a replace (with 1000 recs only no need to check for performance IMHO).ie :

replace all myfield with ;
  Stuff(myField, ;
  At(Chrtran(myField,Chrtran(myField,'0123456789',''),''), myField), ;
  Len(Chrtran(myField,Chrtran(myField,'0123456789',''),'')), ;
  ' '+Chrtran(myField,Chrtran(myField,'0123456789',''),'')+' ')

Cetin