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
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