Re: Two columns have data mixed up need to fix

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 14:27:47 -0600

How do you distingush whether a string value is a "Part Number" or a "name"?
Once you determine this, you can come up with an SQL predicate & use it in
an UPDATE statement like:

UPDATE tbl
   SET col1 = col2, col2 = col1
 WHERE < sql predicate > ;

Also just noticed that you have multiple values delimited by commas in each
column. Do a good analysis on the data involved with respect to your
business model to see if this is a flawed design approach or not. 

-- 
Anith

Relevant Pages

  • Re: Error message on assignment line before rs.update
    ... TenderType as string ... as to what an Update statement would look like based on the Query. ...
    (microsoft.public.vb.database.ado)
  • Re: Forms and ODBC connections
    ... Thank you for your answer but it isn't clear to me the sintax you are using ... for the connection string and the update statement. ... > and the connection string mirrored that of my linked tables. ...
    (microsoft.public.access.formscoding)
  • Re: how to modify an xml field that may be plain text
    ... The update statement in a stored procedure and is actually designed to update any or all fields in the table. ... cases where the field is not an xml fragment but just a string. ... or it could just be this 'blah blah blah'. ... So when updating this field it might need to update just one of the nodes or the entire field (in the case where it's a simple string). ...
    (microsoft.public.sqlserver.xml)
  • Re: Edit records and UPDATE statements
    ... The connection string is in the web.config file and connects to the sql ... The SQL string is: ... my understanding is that cellas you see it in the UPDATE statement ...
    (microsoft.public.dotnet.general)
  • Re: Oracle Stored Proc issues
    ... I use the value in the update statement. ... G Quesnel wrote: ... declare the text variable to be some extra large number, ... string of text to the variable, then the variable will only contain ...
    (comp.databases.oracle.misc)