SQL : Stored procedure execution error

In my stored pro开发者_高级运维cedure I am getting the following error

'price=ROUND(' CONVERT(VARCHAR, changeValue) + '/(1.00- marginPercent), 2) ' + sqlWhere

Error is:

Incorrect syntax near the keyword 'CONVERT'.

I have not found any syntax error. Please help me on this. I'm using SQL Server 2000

---

Seems like you are missing + between price=ROUND( and CONVERT(VARCHAR, changeValue)

---

you have syntax error in query,

correct the syntax error check below one & compare with your query

'price=ROUND('+ CONVERT(VARCHAR, changeValue) + '/(1.00- marginPercent), 2) ' + sqlWhere

look into

ROUND('+ CONVERT(VARCHAR, changeValue) 

---

Have you given correct value at VARCHAR

'price=ROUND(' CONVERT(VARCHAR, changeValue)??

I think there is an error. You have not given the value.