Need to Replace the first character of a string 2

[shelley6]

I need to replace only the first character of a string using SQL Query. For instance:

Is:
3000378920 (or anything starting with a 3)

Should be:
2000378920

I'd appreciate any suggestions

 

[PHV]

UPDATE yourTable
SET yourString='2' & Mid([yourString], 2)
WHERE yourString Like '3*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rjoubert]

UPDATE YourTable SET YourTable.YourField = "2" & Mid([YourField], 2, Len([YourField]))
WHERE (((Left([YourField], "1")) = 3));