Hi timothy 

I was looking to do RegEx matching in a query

I wanted to know if there was already a built in function for this.

But thank you very much for your answer : )

Yes, for now is the best option :(

Ok, Kyle, thanks very much for your help :)

Hi Kyle. So...
I have a hierarchy, a tree. Each node is a row.

To simplify, imagine only 2 fields:
NodeId | ParentId
3 | 2
2 | 1
1 | 0

So, each node knows your father. But I need answer things like:
All nodes that are descendants from node x

OK, I can make a object script method or I can use severals "self inner Join", but I would like to use a more elegant way

Hi Dmitry. Trank you to your answer.

Hmm, ok, dont have WITH, but there any caché's implementation to recursive queries in SQL? My trouble is about hierarchy, I have a table where each record points to parent's id...