Hello,
I want to do a case sensitive search in MS SQL Server, and I have the
following stored procedure that works great when the keyword matches the
whole value stored in a record:
CREATE PROCEDURE mySP
@keyword varchar(150)
AS
BEGIN
SELECT ID,title,description FROM myTable WHERE
BINARY_CHECKSUM(description) LIKE BINARY_CHECKSUM(@keyword)
END
GO
But I also want to do a case sensitive search for a substring of the record,
i.e. that "Thomas" matches the record "his name is Thomas".
How can I use the '%' like in "description LIKE '%'[EMAIL PROTECTED]'%'" to do
an
insensitive search?
Helge
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
