?
Solved

Search and Replace Trim function in SQL statements in Access 97

Posted on 2003-03-06
7
Medium Priority
?
519 Views
Last Modified: 2006-11-17
I need to remove any instances of the Trim function in about 685 queries. I am using Access 97.  The tables used are MSDE linked ODBC data sources.

Is there a Search and Replace function out there that could automate this.

Thanks for your help.

John Desselle
0
Comment
Question by:John Desselle
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 26

Expert Comment

by:Alan Warren
ID: 8085872
0
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 2000 total points
ID: 8085929
An alternative shareware tool:
http://www.rickworld.com/products.html

Works rather nicely and is *considerably* cheaper than SpeedFerret, if you choose to register it.
0
 
LVL 26

Expert Comment

by:Alan Warren
ID: 8085960
trial version o either should get the job done.
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 8085974
Ah, I was looking in the wrong place for the demo version of SF - found it now.
0
 
LVL 3

Expert Comment

by:Koka1
ID: 8095370
Maybe this would help:

Dim q As QueryDef
For Each q In CurrentDb.QueryDefs
q.SQL = Replace(q.SQL, "TRIM", "")
Next q

Good luck
0
 
LVL 12

Expert Comment

by:nexusnation
ID: 8785327
Hi jwdesselle,
This question has been abandoned and needs to be finalized (107 days since last comment).

   You can accept an answer, split the points, or get a refund. Go to
   http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access
0
 
LVL 18

Expert Comment

by:1William
ID: 8884896
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, split points to alanwarren and shanesuebsahakarn
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question