[AccessD] does Access allow Replace in sql window ?

thanks Gustav,

but they are all different length (with first 5 characters being the same)
Actually I just realisesd that all I need is for all values in that column
to be the word "associates" That should be simpler ?

> Hi Oleg
>
> You could do something like:
>
>   Expr1: IIf(Left([YourColumn], 4)='Mash', 'Masha', [YourColumn])
>
> /gustav
>
>
>> 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"
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





-----------------------------------------
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