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

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.

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


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
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.