Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Wild Card Charachters ...

Wild Card Charachters in MS Dynamics GP Web Services

(0) Share

Report

Posted on by Rupali Arde

Hi,

I am developing invoice approval system as a web application using vs2008/asp.net3.5 and c#.
I am using GP web services to retrieve GL Accounts from Dynamics database in to my application.
I need the GL Summery list with GL accounts starting with 2 / 3 / 7 and 8.
I am not able to find proper wild card characters for the Like RestrictionString.

At the back end sql server, I use ' [2378]% ' in the sql query, which is returning gl accounts starting with 2/3/7/8. But its not working for the Like RestrictionString.

Can somebody suggest me proper wild card characters in GP web services?

Thanks in advance!
R