Update Query advice 1

[perrydaniel]

Hi

I have a table that has a reference number, I would like to add a letter to the front of the reference number. How would i go about doing this in an update query?

Thanks

Perry

 

[PHV]

Something like this ?
UPDATE yourTable SET [Reference Number] = "A" & [Reference Number] WHERE Left([Reference Number], 1) <> "A";

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

 

[PHV]

BTW, is the [Reference Number] field defined as numeric ?
If yes, take a look at the ALTER TABLE instruction.

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