[AccessD] does Access allow Replace in sql window ?

hey, I already did it this way --

UPDATE ArtemMARGaps SET Filter = "Citifin"
WHERE filter like "*fin*";

 Hi Oleg
>
>> but they are all different length (with first 5 characters being the
>> same)
>
> If so:
>
>   Expr1: IIf(Left([YourColumn], 5)='Masha', 'Masha', [YourColumn])
>
>> Actually I just realisesd that all I need is for all values in that
>> column to be the word "associates" That should be simpler ?
>
> Ehh - you lost me here ... or do you mean:
>
>   Expr1: IIf(Left([YourColumn], 10)='Associates', 'Associates',
> [YourColumn])
>
> /gustav
>
>
>>> 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