Select * From stock Where description Like "%BRG%"
>I have a table called stock, I have a sql statement to list the stock record, the question is :
>is it to find the record that match certain word like "BRG" for example
>
>stockcode description
>STOCK A BRG A
>STOCK B A BRG
>STOCK V V DESCRIPTION
>STOCK G G DESCRIPTION0
>STOCK J J BRG
>
>I want to list description that contain BRG so the result is
>
>STOCK A BRG A
>STOCK B A BRG
>STOCK J J BRG
>
>
>How to list using the SQL statement ?
>
>Sorry for my english