><snip>
>
>>In that light, I think the PATINDEX solution simply strips out the non-numeric data leaving you with 3153, no?
>
>No. It finds the first non-digit character specified in the pattern and converts everything before that.
Ah, ok. Thanks for the clarification.
Chad
_________________________________
There are 2 types of people in the world:
