Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


SQL Statement: Case sensitive

When I installed my SQL Server 2000, I was asked to set Case Sensitive. Now, I got a problem as follow.

When I query the Student name list, my SQL Statement would be:

Sql = SELECTE * FROM T_Student Where StudentName LIKE '%" & strSearchName & "%'"

When the user type john in the box, namely, strSearchName, it returns nothing; if it is John, it then returns the records that state in the database.

Question to you: How could I get john or JOHN as the same as it is John, meaning that turn case sensitive to case insensitive for searching?

Please note that the field StudenName is formatted as LastName,FirstName. For example, Smith,John.

Any prompt response to my question is greatly appreciated.


  • woogorwoogor Member Posts: 7
    Problem solved.
  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    ___ | | free video tutorials and ebooks about < R Java Swift Scratch Ruby Delphi C PHP Python MATLAB Visual Basic .NET Objective-C Perl Go Visual Basic Assembly PL/SQL JavaScript C# C++ Scala Clojure Awk SAS Dart Transact-SQL Hack Logo Kotlin F# ML Prolog Lua Alice FoxPro Apex ABAP Rust Julia D VBScript LabVIEW COBOL Bash Ada Crystal Erlang Scheme Lisp Fortran /> ______

Sign In or Register to comment.