Hi ,
Try This...
CREATE TABLE #KeyDtls(Keywords VARCHAR(50), UserID INT)
INSERT INTO #KeyDtls (Keywords , UserID )
SELECT 'Children', 101
UNION ALL SELECT 'Family', 101
UNION ALL SELECT 'Room', 102
UNION ALL SELECT 'Girl', 102
UNION ALL SELECT 'Hostel', 103
UNION ALL SELECT 'Shop', 104
CREATE TABLE #SeachTable(Content VARCHAR(100))
INSERT INTO #SeachTable (Content )
SELECT 'Small Boy is standing'
UNION ALL SELECT 'There is a Girl'
UNION ALL SELECT 'He is my Children'
UNION ALL SELECT 'My Family is big'
UNION ALL SELECT 'Family Room is available'
UNION ALL SELECT 'Hostel is ready for bachelor'
UNION ALL SELECT 'Shop is near by'
SELECT * FROM #KeyDtls
SELECT * FROM #SeachTable
DECLARE @UserID INT=101
SELECT Content FROM #SeachTable
INNER JOIN #KeyDtls T1 ON T1.UserID =@UserID
WHERE Content LIKE '%'+T1.Keywords+'%'
Search in Code Project Posts for LIKE Search....
Regards,
GVPrabu