Skip to main content
Participant
June 20, 2008
Question

Removing Text from A Database

  • June 20, 2008
  • 1 reply
  • 273 views
I have an access database that I want to run an internal update query that looks for a specific snipitt of text and removes just that. How would I do that?

Thanks
This topic has been closed for replies.

1 reply

Inspiring
June 21, 2008
You can do it with access, check out the string functions here:
http://www.techonthenet.com/access/functions/index.php

You can also use ASP functions to manipulate the string from a query:
http://www.w3schools.com/VBscript/vbscript_ref_functions.asp

If you want to start using the database in other ways look into using MSSQL 2005 Express - it free and has most of the features of the $$$ version. You can use access as a front end and upload your access dbs to SQL server real easy, you will be glad you took the time.
http://www.microsoft.com/sql/editions/express/default.mspx