Updating records

Results 1 to 3 of 3

Thread: Updating records

  1. #1
    Mark Guest

    Default Updating records

    I have a ton of records that I want to update with a query, but I don&#039;t know how to say it. I want keep the existing value but add a "Q" to the front of it (so that "12345" becomes "Q12345"). Do you know how I can do this? <BR><BR>Logically I want to say something like...<BR>UPDATE customers SET cust_id = Q + cust_id<BR>...which obviously doesn&#039;t work<BR><BR>How can I say it the right way?<BR><BR>Thx!!

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Updating records

    are you saying cust_id can hold charecters<BR><BR>try this<BR><BR>UPDATE customers SET cust_id = &#039;Q&#039; + cust_id<BR>

  3. #3
    Mark Guest

    Default RE: Updating records

    I am so embarrassed. Thanks...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts