>Is there a limit to the number we can use when doing a PADR?
Michel,
I just ran a test and got to 7,000,000 and the speed degraded sop badly that I stopped the test. So the limit is more than 7,000,000 but I ond't know where the function will break.
I think the speed got bad because of the thrashing of RAM on a 7MB character string<g>