[AccessD] does Access allow Replace in sql window ?

Why not try an update query.. 

fill in the appropriate TableName and Fieldnames... 
please back up before you try and it, if you try it..

something like this I think will work..

UPDATE TableName SET TableName.FieldName = "Masha"
WHERE (((TableName.FieldName)="Mash"));



-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
Sent: Wednesday, May 21, 2003 10:09 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] does Access allow Replace in sql window ?


I was pretty sure that it does, but I can't seem to remember/find how.
I need something like this

Edit tblTableName

Select *

Replace "Mash*" with "Masha"




-----------------------------------------
You are entitled to Get 100% FREE perfume (S&H is FREE)!
Click Here: http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com