>>VFP on the whole, has a much richer language - particulary in the string
>>manipulation and data manipulation arena.
>
>Speaking of which, I was trying to write an Append Query in Access the other day and assign cField to cDescription, and STRTRAN(cField, ' ', '_') to cPrimaryKey. Of course, Access doesn't support STRTRAN, so I ended up leaving the spaces in, which is not a wholly satisfactory solution. Any ideas?
Short of
Function StrTran (By Val a$, By Val b$, By Val c$)
[sorry, Garrett, you write the rest]
...none. All the syntax errors in the line above are... well, I know how lucky I am - never had to learn that :)