HI
I have House_info table in database
1-House_info table
|
Id
|
Name
|
Date
|
Behcode
|
Description
|
|
1
|
Sara
|
2012
|
1111
|
Here is India
|
|
2
|
Jack
|
2013
|
2222
|
Here is paris and I love itally and I love parishilton
|
I have datalist1 and BTNSearch in search.aspx page
I want when I click on btnsearch it search in Description Column and if there was the words that contain Itally Or Paris it show Behcode In datalist I wrote below SP
ALTER procedure [dbo].[AdminSearch]
AS
BEGIN
SELECT behcode FROM House_Info WHERE Description LIKE ('%'+'Paris'+'%') or ('%'+'Itally'+'%')
END
But below error occur
Msg 4145, Level 15, State 1, Procedure AdminSearch, Line 10
An expression of non-boolean type specified in a context where a condition is expected, near 'END'.
What should I do ?
Thanks alot
