>yes borislav
>i want sql server view
>i know doesn't work with parameter in view
>i want to create view like
>
>IN VFP
>
>create view view1 as
>select * from table1 where form_type=['C']
>
>THIS VIEW HOW CAN I WRITE IN SQL SEVER
The same way as in VFP (See Cetin's answer).
Open query analyzer, open your database and type:
CREATE VIEW View1 AS
select * from table1 where form_type = ''C''
Press F5
I don't know how you keep values in form_type field with or without quotation marks.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.