In SQL Server that will work, because SQL Server convert the string to DateTime (if it can), VFP doesn't.
BTW in both better use ANSI date format - yyyymmdd, that way you will not have troubles with SET DATEFORMAT (in SQL Server) SET DATE TO (in VFP).
:-)
DTOS() will not be recognised in SQL Server.
If this is eligible system, then work with parameters, do not query directly:
SELECT * FROM tblAbc WHERE DTOS(trans_date) => ? AND DTOS(trans_date) <= ?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
