Dear Walaa,

I've a Resource table with xml column like this. followings are the fields in my table. what I need exactly is that I like to get the result when search by keyword like "Sales".

all the master tables are mapped with this table on 1:1 mapping.

Field1 [Id] : 2

Field2 [Value] :** <MLString> <translation lang="en-US" value="Sales Force" /> <translation lang="fr-FR" value="SALES FORCE" /></MLString>**

Field3 [ShortValue] : <MLString> <translation lang="en-US" value="SF" /> <translation lang="fr-FR" value="SF" /></MLString>

Select * from Locations.LocationResource LR Where LR.ShortValue.value('(/MLString/translation/@value)[2]', 'varchar(30)' ) like '%Sales%'

this is the Query and How can I implement thru the LLBL v2 Coding.

pls help me out by giving some other good idea without using stored procedure if you don't have the code to implement.

Thanks Walaa...

Here are a couple of threads talking about eh same issue: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=5684 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8845

Basicly you'll need to implement your own predicate. Becaue XQuery is not supported out of the box.