A prolem with *'s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could someone remind me of something I've forgotten. I need to return fields
which contain a single asterisk (*)and I am trying to use statements such as

IIf([field]like "***" .......
mid([field],5,1)="*" .....

How's it done? I know it's easy - I just can't remember

Thanks for any help

Jim Jones
 
Back
Top