Function In the InStr Function

Hey.

I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:

I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0).

The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them.

In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so...

Any ideas would be welcomed.

Thanks in advance, Ben.

Before I make you think too much, I thought of a sulotion, tell me if it can work.

If I want to use the Lcase function I should just write like this:

Instr (Start, Lcase(SrcStr),Lcase(Str))

Will this work write?

Take a look at the optional 3rd argument to InStr, maybe that will help you out.

http://msdn.microsoft.com/library/d.../vsfctinstr.asp