Trouble converting a column of digits from string to integer .

%3CLINGO-SUB%20id%3D%22lingo-sub-3546470%22%20slang%3D%22en-US%22%3ETrouble%20converting%20a%20column%20of%20digits%20from%20string%20to%20integer%20.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3546470%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20all%20the%20suggested%20solutions%20but%20no%20success.%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20ideas.%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20date%20I%20have%20tried%3A%3C%2FP%3E%3CP%3EConvert%26nbsp%3B%3C%2FP%3E%3CP%3ECast%3C%2FP%3E%3CP%3EAlter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3546560%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20converting%20a%20column%20of%20digits%20from%20string%20to%20integer%20.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3546560%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3EDoes%20anyone%20have%20any%20ideas.%26nbsp%3B%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1434770%22%20target%3D%22_blank%22%3E%40GavSol%3C%2FA%3E%26nbsp%3B%2C%20idea%20on%20what%3F%3C%2FP%3E%3CP%3EYou%20didn't%20provide%20any%20usefull%20information%2C%20exactly%20close%20to%20no%20information.%3C%2FP%3E%3CP%3EWhich%20SQL%20Server%20version%20are%20you%20using%3F%20What%20do%20you%20want%20to%20convert%20where%3F%20How%20does%20the%20source%20data%20look%20like%3F%20If%20you%20get%20errors%2C%20which%20one%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOlaf%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have tried all the suggested solutions but no success.

Does anyone have any ideas. 

To date I have tried:

Convert 

Cast

Alter

 

1 Reply

 


Does anyone have any ideas. 

@GavSol , idea on what?

You didn't provide any usefull information, exactly close to no information.

Which SQL Server version are you using? What do you want to convert where? How does the source data look like? If you get errors, which one?

 

Olaf