Oh, well that stinks. ;) In that case, I think you'll need to go with some variation of Sergey's solution using PATINDEX.
Chad
>Thanks Chad, but we do not have rights to add any functions to the database because we do not own or manage the database. It is another product our customers use and we are only providing an interface to view data from within our app.
_________________________________
There are 2 types of people in the world:
