I have a db coumn defined as a varchar(50). Stored in that field are mostly numeric numbers that are being treated as text. During a backend insertion to the table I now have values such as this:
I know what number that is supposed to represent and I know the backend process put it there, but is there a quick SQL statement I can run on that table to convert that into an easier to read number. Getting the backend process changed will take time, and I'm looking for a quick fix.