John,

Thanks for all the help you provided. If I get any helpful links regarding this I will post it down here.

Hope someone can help me in this. :ermm:

Yes John. No leading and trailing spaces anywhere.

Here is the actual scenario:

DIM_DETAILS (Lookup Table)

-------------

First_Name | Last_Name | Middle_Name | Addr1 | ...

Thanks for the reply John and sorry I couldn't get back on the issue yesterday. I have already tested the query in the Database end and it works. Somehow the...

Thanks for the reply John.

The values being passed as parameters (?) into the CHARINDEX Function are all character values. As per your advice, I did a CAST for these parameters.

Good...