Yes, it is! It works great! Thank you!
Helge _____ From: Greg Ewing [mailto:[EMAIL PROTECTED] Sent: 27. januar 2005 19:37 To: [email protected] Subject: re: [AspNetAnyQuestionIsOk] Case sensitive search in SQL Server 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] <mailto:[EMAIL PROTECTED] e> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. [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/
