On some occasions, I have the need to incorporate in my SQL the value of the numeric field as is. For example, if I have a lnYear value of 1999 and that I am building a lcSQL string, I would do as is:

lcSQL='SELECT Numero FROM News WHERE Year='+ALLTRIM(STR(lnYear))
&lcSQL

So, this allows me to pass lcSQL as a parameter and have it working in another method. Otherwise, if I would do:

lcSQL='SELECT Numero FROM News WHERE Year=lnYear
&lcSQL

I would need to have lnYear visible in the method.

My question is how can I achieve the same with a date? I want to be optimizable and if I use:

lcSQL='SELECT Numero FROM News WHERE StartDate=CTOD('01/01/1999')
&lcSQL

This won't be.