sql query

[gm000]

hi
thanks for your reply i was very helpful for me regarding this i have a problem which is this

i m using this query it works
SELECT AuthorId, UrlUserName, Urlid, UrlAddress, ChooseMedia, Title, Description, ChooseThumbnail, ChooseTopic, Datetime,
(SELECT COUNT(CommentId) AS Expr1
FROM CommentTable
WHERE (CommentUrlid = Submitnewtable.Urlid)) AS cnt, DATEDIFF(second, Datetime, GETDATE()) AS diff
FROM Submitnewtable
WHERE (Title LIKE '%.com%')
BUT I WANT TO USE A TEXTBOX.TEXT OR STRINGVARIABLE IN THE PLACE OF '%.com%' FOR SEACHING purpose
i also used FREETEXT funciton for searching but it not working and give error which is fulltext index.My database table is not fulltext index enabled and i tried to enable fulltext index but i failed please guide me regarding above query


thanks

[nbiswas]

Hi, coming to ur doubts

Q1) BUT I WANT TO USE A TEXTBOX.TEXT OR STRINGVARIABLE IN THE PLACE OF '%.com%' FOR SEACHING purpose

Ans:

declare @p varchar(50)
set @p = 'name'
select * from MyTable where attribute like '%' + @p + '%'

will give you the same result as

select * from MyTable where attribute like '%name%'

You can use this in a stored proc or in inline query.

So your query will be

WHERE (Title LIKE '%' + @var + '%') where @var will contain '.com'

Q2) My database table is not fulltext index enabled and i tried to enable fulltext index.....

Ans: Look into this

http://www.mssqlcity.com/Articles/Ad...S/SetupFTS.htm

and this

http://www.databasejournal.com/featu...step-Guide.htm

Hope this helps

[gm000]

hi
still i have a confusion i m using this query in asp.vb page now i have
Dim strsearch As String
strsearch = txtsearch1.Text
i want to search records form mytable with the value of strsearch
strsearch is input valule for search a record form mytable
please guide me about this

dadsubmit = New SqlDataAdapter("SELECT AuthorId, UrlUserName, Urlid, UrlAddress, ChooseMedia, Title, Description, ChooseThumbnail, ChooseTopic, Datetime, (SELECT COUNT(CommentId) AS Expr1 FROM CommentTable WHERE (CommentUrlid = Submitnewtable.Urlid)) AS cnt,

DATEDIFF(day, Datetime, GETDATE()) AS diff FROM Submitnewtable WHERE title like '%%' &strsearch , consumit)