Hector --

This is tough for me to answer because I don't have access to SQL Server right now (I'm at a client) but I think you can ALTER TABLE....sure.



>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?