> Sujit Choudhury wrote:
>
> Every time in SQL query I wanted to devide a column by another column
> with a condition (although it is showing syntax is correct) it shows
> an error msg Try to devide by zero.
>
> Can any one help me.
Well Sujit, a number of things to check here:
Is the column numeric? Probably, else you would not have attempted to do
what you are trying to.
Then, check that all records have a value in this column, else the
expression will fail when it encounters a zero value.
To avoid this, pre-select all records with a value <> 0 before the
division, or add a small fraction such as 0.0001 to all values thus
removing any zero value.
HTH Mats.E
--
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:Email/ [EMAIL PROTECTED] ICQ#9517386 :
:---------------------------------------------------------------------:
:Mail/ GISKRAFT, Mats Elfstroem, Vaepplingv 21, SE-227 38 LUND, SWEDEN:
:Phones: +46 46 145959, +46 70 595 3935 :
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
