I figured but wasn't 100% sure. Thanks.

I was looking at pivot but if I pivot each role into a column that doesn't give me the permutations....

So in my example if I pivot the result set would...

That's it. Thanks.

Older laptop running xp and ntfs. The disk isn't shared, single user for a small desktop app. I can understand it being slow but it comes to grinding...

So you're saying that one is by design? HA! That's pretty funny actually. When my customers call in asking what that is, I can now tell them that there...

What do you mean delete the 'field' and re-add it to the report. This is in the main nav bar for paging through any report. It happens on...

That's what I was looking for. Thank you much!

The script I am using is extremely large (the build script generated by Visual Studio Database Developers Edition) and the go statements need to be in there for items where...

Yeah, I'm all for upsizing into SQL but the access db isn't owned by me so I have limited access to it...which means read only access....else I would have converted...

No one uses sql_handle??

The point was to remove extra carriage returns without concatenating the entire string into one long sequence. So in your example:

set @var = '1

2

3'

I would want to be returned...

Thank god for edi...errrr....i mean, yeah, easy typo to make.....

Yeah I agree....in all things set-based, SQL is king but when it comes to string functions....not the best medium to work in

I'll setup a test harness and put regex to...

Yeah that would definitely catch more of them, only problem is invoking the CLR has a good amount of overhead....

This will touch almost every procedure in the system....needs to be...

Uhhhhhhh.....HA

I don't even have words for that one....yeah....

that worked....hehehehehe

thanks!