I am working in SQL 2005 I want to Create view for one table.
Table Name abc
How can i create view for one column I want to search the name and makrs and name and % both have searching on name condition. the queary work seprately. but i want to combine the queary and display result in one table.
The result should be like this :
name id name %
How to do this.
please... Please... Please...
Give me solution