>>
>>But the problem I am having is that I have to pass the variable m.ldDate to the function that actually calls SQL Server (using SPT). I am trying to find a way to create a built-in string that includes the Date Variable without having to pass the variable.
>
>Well there are individuals doing that which some I respect but I don't want to be part of "SQL injection" crimes:) Pass the variable and use parameters. If you insist on passing a string:
>
>cast(dateString as datetime)
>
>is cross compatible (VFP and SQL server both recognize it).
>Cetin
Thank you, Cetin. I don't know what you mean by "SQL injection", I am only SQL Server newbie. And I will see how using CAST() can help me create one-string approach that will work for either SQL Server or VFP. Passing date variable as a parameter right now is not attractive approach.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham