Thanks Lowell!

I just couldn't 'see' that 2 spaces in ' %'. My mind just keep getting stuck in Patindex, Reverse and Rtrim.

It was just a matter of 2 spaces...

Thanks for all the replies.

John, I meant Memo field as a text column.

From what I saw in the replies so far, there is no way to do a query to...

Yes. Only if it ends with ABC would it then be correct.

However, I have some problem trimming a Memo field. RTrim does not accept a Memo field and I m...

That won't work. My 2nd Example will still match. Anyway, Patindex don't accept Memo field. and doing '%ABC' will still consider as a match for 2nd Example also.

I googled those as well... I got my server people to do the latest patching. What I m not certain of is why does this error occur now. If it...

Hi Peter,

Thanks for replying. I think I had a typo up there.

Newbie here, what do you mean by statistics?

Chee Hwee.

Yes, performance is also not ideal. However, thats not a concern at this point of time yet. This query is not executed frequently.

I wish I had the code that construct...

Hi Christopher,

I don't think that was the case. I can control the number of values in the dynamic sql string. Once I reduce the parameter in the IN clause by...

Hi,

  Looks like I found the answer myself... But just in case anyone needs this info, you can go into msdn subscription and login with your passport... Then download the...

I see... But it is strange that when i used the SQL Query analyser, I got results with no duplicates. But if I execute the query through ODBC, I received...