Ummm...I think *NOT QUITE*, Alykins.
*IF* I understand him correctly:
Quote:
|
I want to search into datagrid Surname , Name with one textbox
|
I
think he means he has *TWO* fields in the table,
Surname and
Name and wants to search for a match in *EITHER* of them.
So:
Code:
create proc usp_myDemo
@name varchar()
AS
SELECT [fieldA], [fieldB], ... [fieldN]
FROM tbl_Demo
WHERE [SURNAME] = @name
OR [NAME] = @name
Or, if he means a more general search (e.g., Look for "ja" and find "James" or "Jane" or "Mojani") you would use:
Code:
create proc usp_myDemo
@name varchar()
AS
SELECT [fieldA], [fieldB], ... [fieldN]
FROM tbl_Demo
WHERE [SURNAME] LIKE '%' + @name + '%'
OR [NAME] LIKE '%' + @name + '%'