Thanks for the reply Dev.

I do appreciate everyone's comments.

Cheers - Kirk

Mike, appreciate the suggestion. I think the first was right as qryUC.serial has the full string and tblAAA.Prefix part of it. Both ways worked, but gave zero output. Maybe...

It was that link Lynn, and fair enough too if that's what's needed. Its just the rigid structure for questions, and request to format data as per examples are rather...

Hi Vinu,

I had a good read of the link you suggested. If anything its put me off asking anymore questions here, what I'm hoping to do doesn't sit with any...

Yes, but for reasons I know not,...

Hi Vinu

I will certainly do so, and update with better if I can.

Try it and you'll see that the people on this Forum are so freakin' smart that they'll come...

Thank you, Vinu

>Can you post the table definitions and let us know what you are trying to achieve and on what database platform?

I'm not sure what table definitions to give....

Slightly unsure what best to do, I'm well out of my depth here !

> This is the definition of a left outer join which you are already discussing.

That's not really...

Hi Vinu, I had a look but its a little too advanced for me.

Where has has, e.g.

Select *

From Table1 t1

LEFT OUTER JOIN Table2 t2

ON t1.Col1 = t2.Col2

What are the table...

Sure, thanks. But it's still being designed (badly!)

SELECT qryUC.Serial, qryUC.Title, qryUC.Artist, qryUC.Lyrics

FROM qryUC INNER JOIN tblAAA ON qryUC.Serial = tblAAA.Prefix

WHERE (((qryUC.Lyrics) Like "*climb*"));

So it's where instr(qryUC.Serial,tblAAA.Prefix) > 0.

I'm not even...

Phil, I'm still finding the inclusion of 'TableName' to be a problem. This may be because I'm using Access, not SQL Server. But it is destined to be used...

Thanks for the response, Phil.

I see now using the actual field and table names would have been better.

I'm getting :-

Syntax error (missing operator) in query expression "tblBritburn' Table'.

And the actual...