SQL filters that are setup on trancodes have to have a slightly different format when using SQL  Server as the database.  Use the common sample below to aid your setup.


SQL SERVER SQL STATEMENTS that will work in GENTRAN on SQL Server

Looking at Service Table

trim(service->service) == "IVU" and trim(service->status) = "Active"

Looking at Assess Table

trim(assess->netamt) > 0 and trim(assess->tax_year) = "2013"