Microsoft sql server case sensitive query

Not a good idea. One approach is create a unique index for user name. Sp your query will now just be. FillBy usernameBox. Text, PassBox. Text If login Is Nothing Then. I assume that you are passing parameters to your access query. So from VB you can pass it to your command object like so:. The content you requested has been removed. Ask a question.

Add a comment. Active Oldest Votes. Improve this answer. Irshad 2, 5 5 gold badges 26 26 silver badges 47 47 bronze badges. Alex Alex For nvarchar double it thanks ps2goat. Josh Anderson Josh Anderson 5, 2 2 gold badges 33 33 silver badges 46 46 bronze badges. That is the worst answer possible - take out all indices, force a table scan and totally ignore the reality of being able to change the collation ; — TomTom.

I'm sure there are worse answers -- that query at least functions. From my understanding there's no way to specify case insensitivity using indexes unless you're doing a binary comparison. Gytis TG 6, 17 17 gold badges 35 35 silver badges 52 52 bronze badges. Arun R. Prajapati Arun R. Prajapati 2, 1 1 gold badge 12 12 silver badges 14 14 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.

If I use a column type of nvarchar max , I do indeed get a case insensitive search in PowerApps. Nice one! And a quick Web search suggests that the nvarchar max column type allows 2GB's worth of storage, so certainly no problem with capacity. So is that the answer? Should "text" data types in SQL Server be avoided if you want case insensitive searches? Yes, I would avoid the use of the text data type.

One of the main reasons is that Microsoft recommends against using this data type because it is likely to be discontinued at some point in the future.

Fantastic, timl - thanks for your help. I went ahead and backed up my database and used:. I figure PowerApps must be retrieving all the records and performing the search locally. I'm surprised by this behaviour.

The next time you run up profiler, could you profile a search against a text column to see whether or not you see the same as I do? Skip to main content. Power Apps. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Search instead for. Did you mean:. All posts Previous Topic Next Topic.

Interlock Helper II. Search in Azure SQL data source is case sensitive. So where's the problem? I'm stumped! Message 1 of Accepted Solutions. In response to Interlock.