Re: MI SQL for subtraction

2000-03-09 Thread Stuart Morrison
Hi Vinesh, If I understand you correctly, you would like to subtract 100 from column A Then I would use TableUpdate Column with the expression ColA = 100 - ColA Regards Stuart Pre-Sales and Training Spatial Technologies® Assisting You make faster, more informed decisions through the

MI SQL for subtraction

2000-03-08 Thread Govind, Vinesh
Hi I have a table consisting of a column with values less than 100. What I would like to do is use the value "100" and subtract them from my column. How do I write the SQL query such that 100 is considered a unique number that needs to apply to all of the rows. I know that creating a column