Gail,

I cannot thank you enough. That book used to sell for over $100, just got it for $14 ! It was like a needle in a haystack when...

Actually, I taught myself queries in sql*plus, I never did programming in pl/sql. I haven't programmed in anything except in Basic/Cobol and that was 35 years ago. ...

Sean & Dev,

Thanks for the advice on 2008.

I'm afraid I didn't make myself clear... I taught myself to SQL*Plus/T-SQL (gueries).

Now I work for a Company that uses SQL Server 2005...

Sean,

Thanks.

Is there some way of just referencing the filename and having the Max(len(

done on every field within the filename.

We're forced to upload everything as varchar(255) or...

How can this be done for every field in a table (at once)?

g

select max(datalength(YourColumn)) from YourTable