Insert of ' ' into V data type results in <> value - help, please. 1

[Coder7]

Hello.

I am trying to insert spaces into a column that is data type 'v'.

I insert ' ' and when I look at the table data after the insert, the data value is <> instead of being spaces.

Do any of you know how to get spaces into a V data type?

Thanks for any and all help, gurus!!

 

[blom0344]

Some querytools have the nasty habit of displaying odd symbols for semi-empty fields.
What happens if you run a query on the table like:

Select * from table where field = ' '?


Ties Blom
Information analyst