White space in a field

[JA]

I think this may be a dumb question, but here goes.

If there is a lot of "white space" in a field in SQL Server, does it take up
server space, or is it just ignored?

Example:
Name of product<br>
Manufacturer's Name<br>
Manufacture's Phone number<br>
Instead of this:

Name of product<br>Manufacturer's Name<br>Manufacture's Phone
number<br>
I think it would, but maybe not?

Thanks, J~

[Dan Guzman]

All embedded white space characters are stored, just like the other
characters. The exception is that trailing spaces are removed from varchar
values when ANSI_PADDING OFF is specified (not recommended).

--
Hope this helps.

Dan Guzman
SQL Server MVP

"JA" <ja*****@kc.rr.comwrote in message
news:F7*****************@tornado.rdc-kc.rr.com...

>I think this may be a dumb question, but here goes.

If there is a lot of "white space" in a field in SQL Server, does it take
up server space, or is it just ignored?

Example:
Name of product<br>
Manufacturer's Name<br>
Manufacture's Phone number<br>
Instead of this:

Name of product<br>Manufacturer's Name<br>Manufacture's Phone
number<br>
I think it would, but maybe not?

Thanks, J~