Update Statement

[Belzebu]

I've already ran across most of the SQL tutorial available in the net. But I've yet to find how to edit the no. of characters of a column.

Instruction:
To edit an attribute, which was initially set to "char(25)", to "char(40)".

Hope you guys can help me. Mostly, the tutorial available just show how to edit the value of an attribute. So what's the SQL statement should be? Anyone?

[missinglinq]

You're trying to use a SQL statement to change the size of a field in a table?

[ADezii]

I've already ran across most of the SQL tutorial available in the net. But I've yet to find how to edit the no. of characters of a column.

Instruction:
To edit an attribute, which was initially set to "char(25)", to "char(40)".

Hope you guys can help me. Mostly, the tutorial available just show how to edit the value of an attribute. So what's the SQL statement should be? Anyone?

The following code will change the Maximum size of the [Company] Field in tblEmployees to 50. It was previously 25.

Dim MySQL As String
 
MySQL = "ALTER TABLE tblEmployees ALTER COLUMN Company TEXT (50);"
DoCmd.RunSQL MySQL

[Belzebu]

Yes correct. Change the size of the field.

FYI guys, Im doing this SQL query using access.

You're trying to use a SQL statement to change the size of a field in a table?

[Belzebu]

Thanks mate. I get it right. =)

The following code will change the Maximum size of the [Company] Field in tblEmployees to 50. It was previously 25.

Dim MySQL As String
 
MySQL = "ALTER TABLE tblEmployees ALTER COLUMN Company TEXT (50);"
DoCmd.RunSQL MySQL

[ADezii]

Thanks mate. I get it right. =)

You're welcome, mate.