Not sure how to do this in SQL?

[flyingfish]

Hi All,

if I have the following data in a table

id rec_code desc
1 24 LLLLLLLL
2 32 LLLLLLLL
3 32 SSSSSS
4 95 SSSSSS
5 98 LLLLLLLL
6 98 SSSSSS
7 98 OOOOOO
8 210 OOOOOO

how can I bring back the rec_code 98 in from an SQL query?

Thanks for any help/suggestions!

regards

Davej

[skhanal]

select * from yourtable where rec_code=98;

you should see the tutorial at

http://forums.databasejournal.com/forumdisplay.php?f=15