JDBC Adapter and MS SQL Server with special table and column names

Hi Freaks,

i have trouble with the jdbc adapter and a ms sql database.

How can i define a pi datatype for the folllowing sql (ms sql) statement:

select "Search Name" from "dbo"."client 1$vendor"

where "country code" = 'DE'

Please notice the spaces in the column and table names!

Thanks and regards

Sebastian