469,582 Members | 2,373 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,582 developers. It's quick & easy.

Data Manipulation

5
I'm trying to change some data in database and I'm having some problems.
Scenario: Table A has a columnA with some data A123, B456, C789, 12345.
ColumnA
A123
B456
C789
12345

I'm trying to multiply the digits in the column by 2, leaving the letters as is.
The code I'm using is:

UPDATE Table A

SET
CoulmnA= Replace(CoulmnA,Left(CoulmnA,1),' ')
CoulmnA= CAST(CoulmnA AS INT)
CoulmnA= (AcctNo * 2)
CoulmnA= 'A' & AcctNo
WHERE Left(CoulmnA,1) = 'A'

Does any on know of a simple way to do this.
It will be much appreciated
Jun 21 '06 #1
1 1648
ronverdonk
4,258 Expert 4TB
To be honest, I don't know the simple answer you are looking for. However, have you ever thought of selecting the column into a PHP variable, and do your stuff?

Ronald :cool:
Jul 31 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Ferran Foz | last post: by
1 post views Thread by Oded | last post: by
2 posts views Thread by ajay | last post: by
3 posts views Thread by Ben R. | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.