API seach now more comptible with MS SQL deployments