extracting field with parentheses

[#1]

Hi everybody,

I'm extracting a field from database with the name   Cost Amount (Actual)  but it gives me an error in script,

here is my query

SELECT  [Cost Amount (Actual)] as prix

      FROM [EKG2013].[dbo].[FAD2014$Item Ledger Entry];

regards.

[manojkulkarni]

you need to use fields in doule quote having any special characters

[#3]

it appeared that the field is calculated in navision and doesn't exist in sqlserver

thanks for all