SQL Server Syntax error...

[xjeffx]

Problem with DELETE statement.

$sql="DELETE * FROM tablename WHERE id=44";

gives error:

Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'., SQL state 37000 in SQLExecDirect in...

suggestions?

[maxpup979]

take out the *
should be delete from tablename etc...