Hi All I am receiving a error for incorrect syntax

I am trying to work out the excluding vat value per item

Herewith the code

cmd.CommandText = "SELECT clerkName, dateTime, dateTime, saleNum, round((cast(stockUnitPrice as money)/(1+(cast(vatPercentage as money)/100)),3) as Excl_Selling FROM " & table.tableName & " WHERE round((cast(stockUnitPrice as money)/(1+(cast(vatPercentage as money)/100)),3) as Excl_Selling < 0 ORDER BY clerkName"

This is how I tested it in sql server

use db_my_stores
Select stockCode, stockUnitPrice as incl_Selling,
round((cast(stockUnitPrice as money)/(1+(cast(vatPercentage as money)/100))),3) as Excl_Selling from tbl_072009C0004R0001B0001_SALESLINES

Your test and the commandtext are not the same. You have different number of parenthesis, right next to the "," where the error is telling you to look.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?