Removing Text from A Database

[kplandry]

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

[MikeL7]

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