>>Where do you get syntax error? In T-SQL it's NULL (w/o '.').
>>You don't need to check for tapcomp.fdate > ctod("12/31/9999") and you can use date literal instead of CTOD()
tapcomp.fdate < {^1753/01/01}
>
>I changed the ".NULL." to "NULL" and still get the error. The syntax error is when I insert the record using SQLEXEC().
Can you post your code that generates an error?
--sb--