[AccessD] does Access allow Replace in sql window ?

Gustav Brock gustav at cactus.dk
Wed May 21 10:01:54 CDT 2003


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"



More information about the AccessD mailing list