sql search query( nat..conf..150..)

[chrisb]

Hi I need search query that can be configured in my dataset design. where my string will be nat..conf..150.. it has to return rows containing similar combination

example

textbox input = nat..conf..150..

output:

national confectionery 150gm

any soultion for this type of search?


thanks
chris

 

[Icone]

It is possible with nat.. but seems impossible with nat..conf..150 if its together. You can use textbox autocomplete, it automatically searches for a string that matches in your input as you type. The search results will drop from the textbox.