sql - regarding like query operator -

for below data (well..there many more nodes in team foundation server table need refer to..below sample)

nodes ------------------------ \node1\node2\node3\ \node1\node2\node5\ \node1\node2\node3\node4\ \node1\node2\node3\node4\node5\ 

i wondering if can apply (below query not give required results)

select * table_a nodes '\node1\node2\%\' 

to below data

\node1\node2\node3\ \node1\node2\node5\ 

and (below not give required results)

select * table_a nodes '\node1\node2\%\%\' 

to

\node1\node2\node3\ \node1\node2\node5\ \node1\node2\node3\node4\ 

can above done like operator? pls. suggest.

thanks

you'll need combine 2 terms, , not like:

select * table_a     nodes '\node1\node2\%\' ,    nodes not '\node1\node2\%\%\' 

for first query, , similar solution second. that's "plain sql". there sql server specific functions count number of "\" characters in column, instance.