vijay krish

vijay krish

  • NA
  • 13
  • 27k

how to add filter on table in sqlserver 2000...

Dec 3 2012 2:37 AM
hi....i have a table with data ....now i want to apply filter on that table emp_mast...actually my table contains a column with job...it contains clerk and manager...i wnt only clerks list without using where clause...if i use where clause i have to change in all my forms ...so,i need a filter which displays only clerks list...if i write a query "select * from  emp_mast" which displays only clerks list...bcz the table has filter on it...how to add filter like dat..plz explain me...its urgent
       advance thanx and regards..... 

Answers (1)