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 |
|
genic
Yak Posting Veteran
57 Posts |
 Posted - 2001-04-12 : 13:00:29
|
| i am trying to select the following information where the member name is equal to what a user enters. problem is that they might enter it in all lower case when the member name might have capitilization. here is what i am trying to do, convert the field to varbinary and compare it that way. so no matter what the caps are it should match and get the record. this is the sql:select member_id, m_name, m_password, m_level from forum_membersWHERE (CAST('memeber name' as varbinary(50)) = CAST(m_name as varbinary(50)))now the member name might be equal to "Member name" ...but it does not retrieve a record. no errors. ideas? |
|
|
|
|
|
CAST to select item of different case?