how to put dot and comma in columns of sql table?

Question

hi!
i am create one table and one Column is like:
Message_cost,ex.VAT VARCHAR(20)
how to write query to create this type of columns in a table. i am write like
Message_cost','ex'.'VAT varchar(20). but it shows an error.
Thanks.

Hirendra Sisodiya · Answer

Hello Ajay you can create these types of columns with this query(use '[' and ']' ) : ALTER TABLE Xlbl002 ADD [Message_costex.VAT] varchar ( 20 ) thanks Please mark as answere if it helps

ajay raju · Answer

Thank u Hirendra.