If problem

[jteixeira]

Hello,I have 1 table, 2 columns - desc and barcodeIn the barcode column I products CAP-..... and RES-....I want to make a condition if i select 1, list all products with CAP and 2, list all the products with RESMore or less this:variable->kif k=1 select all from infor where desc like 'CAP%'if k=2 select all from infor where desc like 'RES%'

[justsomeguy]

That's right, but instead of select all you need select *.

[jteixeira]

I put this:variable->kif k=1select * from inforwhere descricao like 'CAP%'if k=2select *from inforwhere descricao like 'RES%'and show me this -> Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '>'.

[justsomeguy]

variable->kif k=1select * from inforwhere descricao like 'CAP%'if k=2select *from inforwhere descricao like 'RES%'

Is that code you are running? I thought it was pseudo-code, to illustrate what you want to do. Is that actual code you are trying to run? What are you trying to run it on? What database are you using?

[jteixeira]

yes it is a pseudo-code but i don't know how to do to run sucessfull (i'am using sql server express)Database -> barcodeTable -> inforComuns -> descricao(description) and codbarras(barcode)

[justsomeguy]

You'll probably want to use something like PHP or ASP to run a different query based on the variable.

if (k == 1)  recordset.Open("SELECT * FROM infor WHERE descricao LIKE 'CAP%'");else  recordset.Open("SELECT * FROM infor WHERE descricao LIKE 'RES%'");