` Comment on an Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Add a comment to an Icetips Article

Please add your comments to this article. Please note that you must provide both a name and a valid email address in order for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!

Your Name:  
Email:  
Header text/Subject:  

Please enter your comment in the box below:
Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

SQL Related Articles: Replacing characters in columns
2004-01-29 -- Rick Martin
 
Newsgroups: softvelocity.clarion.databasedrivers >Maybe a bit off the Clarion topic, but I had a situation where I >wanted to do an update on a mysql table and on one column, replace >certain characters (replace + with a space). > >It looked logical to do something like: > >Update mytable > set mycolumn = select Replace(mycolumn, '+',' ') > >But it didn't like that. After messing with this a bit, I decided to >write a little process in Clarion to take care of this. But I'm >curious how this could be accomplished directly in SQL just for future >reference. Anyone have ideas? Hi Arnor, I don't know if MYSQL syntax is different than MSSQ, but this works for me. Update Engineer Set Name = Replace(Name,'Martin','Martini') I don't think you need the 'Select' part in your example. HTH, Rick Martin Sharpe Software, Inc

Today is November 23, 2024, 3:38 am
This article has been viewed 35211 times.
Google search has resulted in 44 hits on this article since January 25, 2004.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription