Use of ASCII code as a filter

[Lautorp]

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

[v-jiascu-msft]

Hi @Lautorp,

How do you want to use it exactly? I can do it this way in a slicer.

Best Regards!

Dale

[Lautorp]

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 😉

Morten 

[v-jiascu-msft]

Hi @Lautorp,

Can you connect to the SQL directly?

Best Regards,

Dale