Thought so thanks!!

will that do the 'like' on every column?

Thanks Adiga

Thanks guys...

I needed to delete everything from the SQL2000 instance...including all directories? odd but it worked...

Thanks again..good karma to you all

Sorry I meant management studio..

no it doesn't install...that

only configuration manager

Okay since I can't do an inline upgrade..I copied out the MDF & LDF.

then I uninstalled SQL 2000, rebooted.

when I install SQL 2005 it doesn't install Enterprise manager...when I look...

Thanks Nabha!

Exactly what I needed.

Good karma to you.

I figured it out

thanks anyway

Thank man...

It's saying invalid column name borrowerid

Thanks Mark!!

Go it, must be admin

Thanks guys..

Interesting responses..

Thanks guys!

Thankagain..

what if I need to add a where clause to the above query

Where l.branchoffice not in ('01','02')

Thanks Dave!!!

Thanks to the rest of you guys also!

Good karma to you!

Sorry Dave you are correct I meant to be on the 2005

how do I do that calculation?