Incorrect syntax near the keyword 'current' ?

[gopgally]

I am new for sql server so please help me....

select barcode,current, rec retail, sellPrice from products
 

[gpl]

The column 'rec retail' has a space in, the parser does not recognise this so shows the error.

Try this

select barcode,current, [rec retail], sellPrice from products 

[NeoPa]

That is another problem. The error message you are getting (Please post it in the body of the question in future) indicates that Current is a reserved word (Keyword) and should not generally be reused as a field name. If you have a table with it then you should use the following syntax :

SELECT [BarCode]
     , [Current]
     , [Rec Retail]
     , [SellPrice]
FROM   [Products]

Welcome to Bytes!

[gopgally]

Hi
Thank you for your code and idea...
code worked perfectly

[NeoPa]

We're very pleased to have helped I'm sure :)