Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-23 : 09:01:30
|
| James writes "I'm running SQL 7 and I have a table with a text field. I want to search throught the text field for a string but I'm having problems with case sensitivity. The query that I'm running is listed below.Update site_textblocksSet label = replace(label, 'style11', 'Style') where id = 1;How do I get the comparison between the two strings to be case sensitive?Thanks" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-07-23 : 09:08:52
|
| Check out this article:[url]http://www.microsoft.com/sql/techinfo/tips/administration/casesensitive.asp[/url]Edited by - andre on 07/23/2002 09:27:16 |
 |
|
|
|
|
|
Case Sensitivity