472,145 Members | 1,449 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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 1686
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 Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.