What! :)
How can I change the field data type in SQL Server?

The Enterprise Manager does not let me change it. Can I change it using ALTER TABLE?


>Try switching it to Varchar and see what happens.
>
>>The field data type is CHAR(6) and it accepts NULL values. There is no index associated to this field.
>>
>>
>>>What is the SQL Server data type? Varchar, text, char, what?
>>>
>>>>This question is NOT about VFP but here is the only place where I can ask it.
>>>>
>>>>I am replacing a character value in a SQL server table and SQL Server it is removing trailing blanks. I am SURE that VFP is NOT the problem because when I replace the value using the ISQL/W tool that comes with SQL Server I have the same problem.
>>>>
>>>>Here is what I do:
>>>> UPDATE mytable
>>>> SET somefield = 'abc '
>>>> WHERE pk_mytable = 56.00
>>>>
>>>>When I retrieve the value with:
>>>> SELECT ']' + somefield + '['
>>>> FROM mytable
>>>> WHERE pk_mytable = 56.00
>>>>
>>>>I get ']abc[' instead of ']abc ['
>>>>
>>>>I am having this problem ONLY WITH ONE TABLE. My other tables do not have this same behavior.
>>>>
>>>>Any ideas? Any suggestions?