Help Converting and Access VLOOKUP Function to a SQL statement

[penndro]

Hi I have recently converted my access database tables over to SQL Server 2008 and in the process of converting my queries to views on the server as well. I am having difficulties converting this access vlookup function and could use some help with the SQL Syntax:

DLookUp('Close','[ref_Stock Index]','([stockDate]) = '' & Format([VestDate],'mm\,dd\,yyyy') & '''))) AS VestRate

Any help would be appreciated.

Thanks

 

[SkipVought]

Arguments are

Table
Field
Criteria

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[penndro]

So Skip, I am not so sure about the SQL structure to include this in my overall query. Can i call it like this:

FROM[ref_Stock Index]
SELECT[Close],
WHERE [in query].[VestDate] = [in lookup table].[Stock Date]