How to search a XML field which gives maxim search results

[EDN Admin]

<span style="color:#526569; font-family:Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:normal; text-align:left; background-color:#f4f7f5 How to search a XML field which gives maxim search results . I use where statement it can only search
the field and the correct match text.
<div style="color:#526569; font-family:Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:normal; text-align:left

<div style="color:#526569; font-family:Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:normal; text-align:left
for example :if i have two feilds such as <title>baby</title>
<div style="color:#526569; font-family:Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:normal; text-align:left
<title>baby happy</title>
<div style="color:#526569; font-family:Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:normal; text-align:left

<div style="color:#526569; font-family:Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:normal; text-align:left
and if i search the word baby it give me the first only as result.i want to get the second statement too since it also has the word baby. <hr class="sig Solve your Problems @ http://www.livetut.com/

View the full article