Folks,
I noticed an earlier thread in which Miles asked about using a well-known VFP function in SQL.
I have a similar question. I would like to be coding SQL expressions that are certain to run on any platform (well, you know, as much as one can be certain of such things).
Is there an online resource, perhaps similar to the W3C, that publishes a standard for extended syntax elements such as string concatenation, type conversions, and other things? Does such a standard even exist?
For instance, in VFP I might do something like
SELECT TTOC(MyDateTime) as "CharDateTime", Column1 + Column2 as "TwoStringsTogether"....
But I have been mixing VFP syntax into my SQL for so long that I do not know what I will be facing if I try to purify my code to be back-end independent. Can I still accomplish these things, or do I have to code up different versions because every back-end has a different command for ISNULL()?
Any pointers much appreciated...