I'm trying to filter an inventory tabel from my Dynamics C5 but the Location colum on my primary location is marked with an ASCII code (┐) in the SQL db. Does anyone knows how I can use this as a filter? PS: It dosn't work just trying it in ;-) BR Morten
How do you want to use it exactly? I can do it this way in a slicer.
In my Inventory table in my Dynamics C5, my warehouse location is set with a blank character in the C5 system, but in the SQL table an ASCII character (CHAR(2)) is set.
I want to filter my inventory record so I only see my blank location.
Hope that makes sence ;-)
Can you connect to the SQL directly?