Helge, can you use Full Text Indexes?� If you can you would then have the option to use the CONTAINS keyword and some other more advanced search options.� Is that a possibility?
Greg Ewing [MVP] www.citidc.com ---------------------------------------- From: "Helge Thomas Hellerud" <[EMAIL PROTECTED]> Sent: Thursday, January 27, 2005 8:37 AM To: [email protected] Subject: [AspNetAnyQuestionIsOk] Case sensitive search in SQL Server 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 [Non-text portions of this message have been removed] 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/
