[RESOLVED] Limit + Mssql

Hi all,

What is the equivalent of mysql's LIMIT clause for MSSQL Server?

Thanks.

$find_date = mssql_query("select date from date where date = '$value' 
				and course_ID = '$course'	LIMIT 1");