Jeanne Boyarsky wrote:What do you mean by "skipping"? It looks like you are trying to find matches. Or at least would be if you were querying a table other than dual.
Oops..Sorry my Bad...Correcting the requirement
- start with & ( might also be followed by # )
- ends with ;
- should not contain spaces
- should NOT be from & amp; & lt; & gt; & quot; (Please ignore the space after & in my post, its because the forum parses them even in the Code tag)