VALUE SEARCH IN ANALYZER

[jorg32]

Hi,

I've had the next error :

"The conversion of the nvarchar value '200408160214 ' overflowed an int column. Maximum integer value exceeded."

I trye to search this value in the Select, but cann't find it!!

Is there something extra in the Analyzer to search a specific value into a complete table?

THX

Jorg

 

[hmckillop]

you need to convert it to a BIGINT value, as it says the max int value is exceeded.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[SQLSister]

Looks to me like you are putting a date into an integer field.

Questions about posting. See faq183-874

 

[jorg32]

I found the column and changed it to BIGINT and the Select works, BUT..... The strange thing is that I couldn't find the value '200408160214 ' in it??!!

What can I do to find it because this column has to be INT again!?

 

[zhavic]

It could be an expression which results in that value
Post there your SELECT statement, if you can

Zhavic


---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.