I have a simple query
select gvwr from comm_veh where user_id=123
the problem is that the gvwr field is not consistant
the data that users have entered can have a value from 20 to 80000
this is a weight value. All of the weights should be over 1000
is there a way that I can multiply the gvwr field by 1000 for every entry that is less than a thousand?
by the way the gvwr field is an integer
Thanks for your help
Hate to say it, but it sounds like you have a serious data hygeine issue. Somehow I doubt that a simple *1000 if less than 1000 would make ANY kind of logical sense. If it does, you need to fix the values permanently, and then set some constraints.