Calling an SQL function from teststand

[Tereng]

I hope someone will be able to help me out here.

Im trying to use the following SQL statement in Teststand 3.0:

select first datepart(week, dateadd(day, -1, '2007-02-12'))

It should return which week that 2007-02-12 corresponds to. In this case week 7.

The first part where Im making the SQL statement works it seems. But then I want to retrive the data

which is done in the data operation step. But this step requires that I link the data to the right column in the database

as this is a function that I am using in the database (to calculate the week).

Either Teststand is a bit primitive when it comes to using SQL and can only access columns and no more.

Or I have simply overlooked something.