Posted by geekwagon on 10/02/66 11:47

Not a SQL guy but can do enough to be dangerous :)

Trying to update a record. We have records that have a field with data
surrounded by some comment text such as *** Previous Public Solution
*** Start and *** Previous Public Solution *** End . What I am trying
to do is write a SQL statement that will:

Check that field C100 = TICKET0001 (to test with one record before
running on whole db)
Check that field C101 is = Closed
Check that field C102 is null
Copy field C103 data to field C102 and strip out any words such as ***
Previous Public Solution *** Start and *** Previous Public Solution
*** end

Thanks for any help!
Kevin

• Next in forum: LogReader Agent Lacks Required Privilege
• Prev in forum: Re: SQL2005 collation vs Oracle
• Thread view: update SQL field with stripped data from other field

[Reply to this message]