update with iif function in access

[learning_grexcel]

i tried to update a field in a table with the following code but it doesn't work

update table set system = iif(name='tim*', xyzsystem, "othersystem")

if in name field value starts with tim*, it should put xyzsystem, otherwise othersystem

 

[Norie]

Try you can't use = when using wildcards, it will look for an exact match.

So the condition name = 'tim*' is looking for the string 'tim*' not beginning with 'tim'.

You could try this.

update table set system = iif(name Like "tim*", xyzsystem, "othersystem")

Or this.

update table set system = iif(InStr(name,"tim*")>0 , xyzsystem, "othersystem")

 

[learning_grexcel]

thanks mate
can I use OR statement like below?

update table set system = iif(name like "tim*" or "rim*", xyzsystem, "othersystem")