Forum Discussion

Lautorp's avatar
Lautorp
Frequent Visitor
8 years ago

Use of ASCII code as a filter

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

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Lautorp,

     

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

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • Lautorp's avatar
      Lautorp
      Frequent Visitor
      8 years ago

      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