Localizable Data in a SQL Database

Hello all,
I'm working on an ASP.NET with a SQL server for database. Some of the tables, for example, contain information such as different types of Fabrics (silk, cotton, etc..) . I'd like to have this table localizable (English and French for instance).

Is this possible ? Is there an equivalent of resource files in SQL server ?
Or do I have to do this manually ? (have 2 separate fields in the table for those 2 locales)

SQL Server provides the storage structure, but it doesn't do anything for translating. You will have to translate the data, provide different columns for it, and select the appropriate column based on a locale in your application