Viewing 3 posts - 1 through 3 (of 3 total)
Ah.... how true, it's always the spec!
It actually turned out that the three character values should get NO update (ok people, make up your minds!!). Here's what worked:
UPDATE tablename
SET field...
February 10, 2006 at 5:27 am
#620075
It worked.
But.... for let's say 250, I realize I need it to be 250.00 (it currently is 250. just like I asked for!)
ALL others worked great!
Can I do this...
February 9, 2006 at 9:54 am
#619844
Sure...
The field may have the following values:
250
25001
7265
V4521
And I need them to be
250.
250.01
726.5
V45.21
Does that help?
February 9, 2006 at 8:08 am
#619802