Re: How to know the maxmimum length of data in a perticular column?

2003-07-28 Thread Karam Chand
Great. That does it. Thanks. Thanks. Thanks. Karam --- Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Jul 28), Karam Chand said: > > Greetings > > > > Is there any query to know the maximum string > length > > of data in every column of the table? > > > > For eg, if I have data -

Re: How to know the maxmimum length of data in a perticular column?

2003-07-28 Thread Dan Nelson
In the last episode (Jul 28), Karam Chand said: > Greetings > > Is there any query to know the maximum string length > of data in every column of the table? > > For eg, if I have data - > > 1,[EMAIL PROTECTED],2000-12-12 > 20,[EMAIL PROTECTED],NULL > ... > > It will return me > > 2,15,10 SEL

How to know the maxmimum length of data in a perticular column?

2003-07-28 Thread Karam Chand
Greetings Is there any query to know the maximum string length of data in every column of the table? For eg, if I have data - 1,[EMAIL PROTECTED],2000-12-12 20,[EMAIL PROTECTED],NULL ... It will return me 2,15,10 I hope I make myself clear. Thanks in advance. Karam __