We have a field value on the Part table that is returning some unexpected results. Specifically the Part.PartNum field. This table is synced with Snowflake each night but we suddenly started getting an error on this table that the data was not readable. After digging in deeper we found that there is a part number that returns some strange results depending on how it is queried.
Using a simple “Select * from erp.part where partnum = ‘POTF-114164-CUB’” I get what you would expect. A single row of data with the part information.
However, if I use a wild card to query it returns 2 rows of data for the same partnum value.
“select * from dbo.part where partnum like ‘POTF-114164%’”
Select “Distinct” did not clear it either so there is clearly something different. So I thought, well let me see what is different. I copied the values from both rows of data and pasted to notepad and there is an extra character hidden in there. Has anyone seen something like this before?
Epicor seems to ignore it and works fine but our data warehouse is balking at it which is causing multiple issues with our PowerBI reporting that uses the Snowflake data warehouse for reporting.