Hi All - I'm using the OPENROWSET function which imports a CSV file into a table on the server.
There's a column on there which is numeric with a capitalized ALPHA character in front of it:
When I import it, it automatically converts the value to currency:
I've tried casting the value as nvarchar, but always drops the 1st character.
The only way around this is by manually replacing the capital letter with a small letter on the CSV file.
Any ideas? Thanks!