filter - Wild card usage in XML -

need filter values containing b in db2 table. (we use tool links xml db2)

when use "b*" filters values has b first character when give "*b*" takes values in database

<desc value ="*b*"> not working

is there other way prefix wildcard character searching elements.

i second peter, use '%b%' see wildcards in db2 sql

ofcourse db2 supports wildcard chars,

use % clause in case char datatype

for eg.

select * your_table your_column '%1234%'

this search matches substring 1234 anywhere in string & result desired: 1234 1234ab 1234abcd ab1234cd

also

basic sql coding db2 universal database os/390 (under 'searching string patterns);

sql has powerful predicate allows search patterns in character string columns. predicate. suppose want generate list of candidates first name starts letter g.

select fname,lname,wphone,hphone candidate fname 'g%' order lname,fname 

in query, use wildcard character predicate. in sql, percent character (%) substitute 0 or more characters. search string g% can substituted names george, gary, ginger, , on (since percent character can substitute 0 or more characters, search string can single letter g).

the percent character can used place in search string. can used many times need it. percent sign not case-sensitive, can take place of uppercase or lowercase letters. however, constant characters included in search string case-sensitive.