S
scottemick
Guest
I checked and the only data in the netsales column I am working with is numeric, commas, and periods. Yet if I use the progress replace function or even the odbc replace function to remove the commas, I still get the Invalid number string(7498) error after some row retrieval has occurred. If I do the same select to progress using odbc linked server in mssql the select works because presumably sql server is downloading all the rows to a temp table and then applying the replace and then cast to numeric itself. This implies something is wrong with progress itself. Why can't progress do a simple replace? And yes I checked for nulls...Could there be embedded special characters?
Continue reading...
Continue reading...