Re: howto ignore whitespace in select query

From: San Tuon (anonymous_at_discussions.microsoft.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 04:45:54 -0800

That did the trick! Great.

Regards San

>-----Original Message-----
>hi san,
>
>Use varchar datatype this will take only storage space,
of the actual length in bytes of the
>data entered.
>
>Use char datatype when the data values in a column are
expected to be consistently close to
>the same size. For example Sex that is going to be 'F'
or 'M'. or marital status like 'Single'
>or 'Married' etc.
>
>Use varchar datatype when the data values in a column
are expected to vary considerably in
>size.
>
>--
>Vishal Parkar
>vgparkar@yahoo.co.in
>
>
>.
>