Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dolly
Starting Member
3 Posts |
 Posted - 2005-01-19 : 17:06:18
|
| I am converting some varchar values(containing only numbers) of length 20 to bigint...convert(bigint,var)The statement worked fine before , but now after new inputs, it generates an error :Server: Msg 8114, Level 16, State 5, Line 1Error converting data type varchar to bigint.I checked the varchar value and its in the range of bigintAny ideas how to solve this will be appreciatedthanksdolly |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
|
|
|
|
|
converting varchar to bigint
