I have a table in my SQL-Server database 'Vendor' with 'Vendor_Name' and 'Vendor_Type' as fields.
I want to get a recordset which should contain list of Vendor Names but only for the specified vendor type.

I will supply the vendor type from vb code , i want to do this from a view only But what should be the syntax of view ?

Although this can be done using a stored procedure which works for SQL-Server only but not with oracle.

Plase reply if you have any idea.