Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
sql like |
Fri, Feb 8 2008 10:58 AM | Permanent Link |
Allan Brocklehurst | hello;
Stats: V 4.25 Build 7 Problem r as the Project managers say "an Opportunity") I need to remove all of the occurrences in 1 field with the values from another field as in this failed attempt UPDATE vendors_20080207 SET [Street Name1] = REPLACE ([POBox] WITH '' IN [Street Name1]) WHERE [Street Name1] LIKE %[POBox]%; TIA aLLAN Attachments: brock.vcf |
Fri, Feb 8 2008 12:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Allan,
<< Problem r as the Project managers say "an Opportunity") I need to remove all of the occurrences in 1 field with the values from another field as in this failed attempt >> Roy's answer is right-on. Make those replacements and you should be all set. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Feb 8 2008 2:03 PM | Permanent Link |
Allan Brocklehurst | Thanks to you both.
my head is spinning at the data I have to clean up here Allan Tim Young [Elevate Software] wrote: > Allan, > > << Problem r as the Project managers say "an Opportunity") I need to > remove all of the occurrences in 1 field with the values from another field > as in this failed attempt >> > > Roy's answer is right-on. Make those replacements and you should be all > set. > Attachments: brock.vcf |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |