Student Table Structure
Firstname Lastname FullName Age
ABC XYZ ABCXYZ 12
DEF GHI DEFGHI 14
JKL MNO JKLMNO 16
I create an SP as below
The search can be done by either using Firstname or Lastname or Fullname or Age.
For e.g if I'm searching by providing the Firstname alone then the other parameters are blank/null...
where firstname like '@i_firstname%'
and lastname like '@i_lastname%'
and fullname like '@i_fullname%'
and age = @i_age
How the search can be achieved by providing any one of the parameter?
Reputation is what other people know about you. Honor is what you know about yourself."--