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 |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-01-18 : 00:29:39
|
| hi,i want to write a query for data comparingas for example in case of password if i write where condition as WHERE PASSWORD= @PASSWORDin data in database is in upper case and if i compare data which is in lower case it shold not accepthow i can write query to above conditionMalathi Rao |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-18 : 01:33:47
|
| where convert(varbinary, password) = convert(varbinary, @password)where password collate <some collations with CS> = @password <some collations with CS>Peter LarssonHelsingborg, Sweden |
 |
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-18 : 03:11:45
|
| and if u want permanently make your database case sensitive, then u need to change the collation.Madhu |
|
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-01-18 : 04:07:17
|
| Thank You PesoYour Soltion is working and easyMalathi Rao |
|
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-01-18 : 04:08:39
|
| Madhui did't get youMalathi Rao |
|
|
|
|
|
|
data comparing