The attached utility is to identify and generate a List of Data which have Line Feed and Horizontal Tab.The utility can be used before starting the data migration from NAV 2009 or before to NAV 2013 or higher.
Why we need It ?
When a customer using NAV 2009 or Previous Version, copy data from Excel into navision System used to append Line Feed and Character Feed in the Data (Navision Tables).
After upgrade to NAV 2013 or higher the SQL Still contain the Line and Character feed data but Navision RTC Client While Trying to Fetch the Records automatically search for a record without Special charters and end up by not allowing you to view the record.
Using attached query before upgrade, you can identify the data issue and correct it from NAVISION Exe (not SQL) because we are talking about Primary Keys whose rename will impact the other related tables.
For Details how to Execute Query Refer -
Latest Version - http://saurav-nav.blogspot.in/2016/04/upgrade-from-classic-to-rtc-issue-with.html
How to Execute - http://saurav-nav.blogspot.in/2015/09/upgrade-from-classic-to-rtc-issue-with.html
Your Comments and Feedback are much awaited.