Thanks for the insight on STUFF ..totally over looked that.

Cheers

Barry

Thanks Folks..the query was indeed valid but for reasons unknown it wouldn't function through a certain web module (third party) .net app.

Different module and tweaked connection string..as well as through...

Thanks Robert

Thanks jcdyntek

I utilized Roberts example (exactly what I needed) with some minor changes and retrofit to real structure.

Much appreciated.

For anyone interested here is a working revision using five...

Thanks IanScarlett that resolved nicely and queued me to research more.

Thanks again

b

John

Yes to all that .. going cross-eyed

re: application controlled roles ... I think there is merit to that

I have now been able to reinstate the application's authentication mode...

Hey John

NEGATIVE on both queries

(0 row(s) affected)

Tested with other databases .. results as expected

Running from the problem database .. no results on both queries

Tested on 2 separate machines (same database)...