Sql

[hallmat]

i have looked and searhed on here but cant seem to find anything

here is my problem

i want to know how to devide or multipy a colum in the SQL


many thanks

 

[Geordiehc]

Maybes take the value and apply to a d number and do it from there? Say

#IF
Mov D0
#ACT
INC D0 D0
SET D0

Not sure if they can be added to themselves or not i only know what i use.

 

[hallmat]

no i mean actually in the DB itself

Like Coloum 1 Devided by 50 and such

 

[BlackT]

SQL query:

SELECT your_column/50 as divided FROM your_table

HTH

 

[hallmat]

i tryed that before but it didnt work kept giving me errors

 

[BlackT]

And those errors were saying..... ?

 

[hallmat]

ok its not giving me any errors but it wont devide the contence of the coloum

 

[Tomo]

If i'm doing alot of work on a db i usually export it and edit it in excel then restore the data

/Tomo

 

[BlackT]

I don't have MSSQL here at work to test but it may not work because the column type isn't a numeric type?

 

[hallmat]

hmmm ok m8 well i will eep tyring i might try Excel like i normaly do but didnt for this :S lol

anywya cheers for the help