SQL guru badly needed

[Mundi]

hi, I am creating a view that consists of one table, but I need to do something like this:

create view something
as
select * from banks
where name = "Variable"
and id = "variable"
or something = "variable2"
etc.

how do I create a view with variables in it???

Thank you so much!


Computers and software @ EJS

[forty7]

not a sql guru, but i don't know that you can create a view with parameters. i believe you want a stored procedure. you might try posting this question in the VB forum. there are lots of folks in there that know a lot about stored procedures.

thanx/good luck,
adam