Update query

[Monzer]

Hi; I cant beleive that I cant solve this one!!!

I have an update query and its going to update several fields based on parameters. Its all good and working fine except one field. Its the ID field, I just want it to update this field by adding the letter "R" before the ID number.

EX: if the ID field is "565" I want the query to update it to "R565". The ID field is a text field already.

Thanks in advance for any help.

 

[PHV]

UPDATE yourTable SET ID = "R" & ID WHERE ID Like '[0-9]*'

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

 

[Monzer]

Hi PHV;

The query didnt work. It updated the ID field to -1.

Thanks

 

[lespaul]

you mean you ran the exact query that PHV listed above and it changed ALL the ID fields to -1?

Leslie

 

[Monzer]

Hi;

I was trying it only with one record. Its original ID was 200 and after I ran the update query it changed to -1.

Thanks

 

[lespaul]

why don't you post the SQL you're using.

Leslie