David Burrows (1/14/2014)
You cannot cast 'EFT0000000220' to bigint.You can cast the numerical part, ie CAST(SUBSTRING('EFT0000000220',4,10) as bigint)
What David is saying: the text part "EFT" can not be converted to a numeric value. Therefor you have to remove these characters from the value (using the SUBSTRING function). The remaing text represents a value tht can be converted to a numeric (BIGINT) value.