You'll need to use the SQL dialect it supports.
This (but I didn't check the syntax) is how I would do it in MS Access:
iif(left(ac,1)="R";"100"&right(ac,5);iif(left(ac,1)="M";"200"&right(ac,5);iif(left(ac,1)="T";"300"&right(ac,5)))
It isn't exactly SQL, I think, but it's an expression MS Access understands. But the use of substrings and string concatenation should be supported by your DBMS also.
By the way, as a programmer you should know the difference between a digit and a number, so you can use the right term in the specification, the documentation and the test report.
Kees
Kees
Hello, I'm new to scripting so stick with me. I'm trying to create a script that will transform the column values in my Table. I'm currently using SQL Management Studio.
Here's what I'm trying to do:
I have a column with account numbers in this form:
R12345
M23456
T12345
I'm trying to convert the first letter to a sequence of numbers then keep the remaining numbers. For example
R12345 to 10012345
M23456 to 20023456
T12345 to 30012345
I cant seem to find the file to run this script off of
The reason I'm doing this is to create a 1 to 1 relation with this table and another table that is in the form of just those numbers.I've been stuck on this problem for some time now
I have way too many records in this table to do it myself. Any thoughts on how I should go about doing this? Any particular DBMS or scripting language that I should be using?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic