Thank you for your swift reply.

I will give this a try.

Paul

Ah I see. Ok thanks.

Is it possible that you could show me an example such a query?

I am sorry... but I don't know what you mean.

:ermm:

I will do that.

Thanks for your valuable assistance.

Thank you G-Squared.

Woah! That is far more complicated than my SQL knowledge allows. I will need to do a crash course in how this works. I fI...

I am sorry about that

Hi again,

Just to get back to this issue. Yes, going forward there are going to be massive changes to the data entry.. with a complete application redesign. However...

and I actually DID press F1 and read a little more. Because it worked I took more interest. I suspect if it took me too long to work...

Oh I totally understand that point Jeff. And I agree with it. The lazy side of me is just always grateful for being spoon-fed of course.

Nonetheless this exercise has...

Thanks everyone for your swift responses.

After a little testing I have taken the advice of Jeff Moden (with the vital example given by Paul White!). I had not realised...

Thanks for the advice Lynn. I will try the first suggestion.

Thanks for your help on this one, Da Zero.

Great advice!

Paul

Thanks a bundle, Phil.

That worked perfectly.

Paul

Thanks for your reply Phil. Much appreciated... and a good idea.

Can you help with the Expression?

I have tried the following, which fails:

isnull(likes_fish) ? 0 : [likes fish]

and

!isnull(likes fish) ?...

My apologies. I didn't read properly!

You are refering to FINDSTRING, not SUBSTRING.

Thanks for the pointer. I'll give it a go.

Paul