That is helpful.  I had a client claim that they needed to use a SELECT to set a value within a stored proc, or was it a user defined function? ...

If you are using a pre-defined script, you could try including print statements with whatever you like inside, including full syntax of your statement if that is what you want. ...

Suggest you provide some more facts so that others may be able to get a better picture of your situation.  How long do you wait? There is some overhead stuff...

Maybe if you could provide a few more details related to what your goal is that you are doing this for, it will cause additional replys.

The only suggestion I could...

I will make a note to look for that book, if you remember the title send me a message with it, thanks!

Just to clarify, my client wants to use varchar...

mlipham (sorry do not see your name),

Thanks for the additional information.  Although from what I looked at, there is also another 2 bytes per varchar column, probably for the individual...

Philip,

Many thanks for the BOL directions.  I do see the addition of 2 in the formula listed with #4 of Estimating the size of a Table.  It is not explained...