How do I add a 0 to the end of a value in a field?

I have a field (int), and I would like to add a zero to every value in that field?  How could I do this update.  What would the qry look like?
indy500fanAsked:
Who is Participating?
 
Don SmithCommented:
Why not just multiply it by ten?

e.g. update mytable set fld1 = fld1 * 10
0
 
rafranciscoCommented:
UPDATE YourTable
SET YourColumn = 0
0
 
rafranciscoCommented:
or

UPDATE YourTable
SET YourColumn = YourColumn * 10
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
PePiCommented:
by adding a zero do you mean 1 + 0 = 1 or 1 add 0 = 10?

if the former:

    Update yourTable SET
        field = field + 0

if the latter:

    Update yourTable SET
        field = field * 10
0
 
PePiCommented:
doh! ra quick on the draw! ;)
0
 
indy500fanAuthor Commented:
I mean, I have the integer 40423434 and I want it to be changed to 404234340

Does that make sense?  I think that smithsys has it.  If you multiplied 40423434 by 10, you would get 40423434, thereby updating the value.

Thanks!

Eric
0
 
indy500fanAuthor Commented:
Thanks for all your help.  Wow you guys under the DB forum are FAST!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.